Forum Discussion

Andy1883's avatar
Andy1883
Copper Contributor
Jul 01, 2024

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...
BI & Data Analysis
SergeiBaklan's avatar
SergeiBaklan
MVP

Andy1883 

Perhaps you may connect directly to the web to get data. If to save CSV is more preferrable from performance point of view.

Andy1883's avatar
Andy1883
Copper Contributor
Jul 09, 2024
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?
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jul 09, 2024

    Andy1883 

    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

Resources