Updating Files on OneDrive

[AndrewKent]

Hi,

I have a Power BI dashboard that links to a "Date Table" .csv file that is located on my OneDrive for Business. I have recently added a few new columns to this file (updating the original file) however when I use "Edit Queries" within Power BI Desktop, it doesn't recognise that I have added additional columns.

The strange thing is that in the relationship view, the columns are there (albiet appended as the last columns instead of where they are positioned in the file) and if I save the file locally and link using Get Data>CSV (instead of Get Data>Web) then it works fine.

Can anyone support?

Andy

[v-qiuyu-msft · Accepted solution]

Hi @AndrewKent,

Based on my test, when we connect to the .CSV files stores in OneDrive for Business use web data source, the auto generated Power Query is:

= Csv.Document(Web.Contents("https://microsoft-my.sharepoint.com/personal/v-qiuyu_microsoft_com/Documents/test0117.csv"),[Delimit...",",Columns=3, Encoding=1252, QuoteStyle=QuoteStyle.None])

So if we add another columns in this .csv files, it will only display three columns. You can remove "Columns=3" from the formula, when we click refresh button, it will retrieve all columns. See: Csv.Document.

Best Regards,
Qiuyun Yu

[AndrewKent]

Excellent! I assumed as standard that you had to determine the volume of columns in the file as part of the code? Seems to work fine when I test them.

Thanks for your support.