Forum Discussion
Andy1883
Jul 01, 2024Copper Contributor
EOM data ready for power BI
Hi Team Our internal customers web-based EOM data is populated monthly. I can download and save into an excel easy enough. The question is how am I best to save it and in what format to allow easy...
Andy1883
Jul 09, 2024Copper Contributor
Hi
Thanks for that.
I changed the file to CSV and started adding additional months data but it is not transferring over when i refresh everything. any ideas?
Thanks for that.
I changed the file to CSV and started adding additional months data but it is not transferring over when i refresh everything. any ideas?
SergeiBaklan
Jul 09, 2024MVP
When you create the query first time, buy default it put into parameters number of found columns, e.g.
= Csv.Document(File.Contents("C:\file.csv"),[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None])
Change number of columns on null
= Csv.Document(File.Contents("C:\file.csv"),[Delimiter=",", Columns=null, Encoding=1252, QuoteStyle=QuoteStyle.None])
with next refresh it takes actual non-empty columns.
And do not hardcode column names on next steps, e.g. type change