Refreshing data in Query Editor doesn't work

[mafioso]

I have a csv file with some row/cols. If I add one column in the file and save it, I want to refresh the data in the Query Editor.

But that doesn't work. It works perferctly using an Excel file but with a csv file it doesn't. Do you have any ideas how to solve this issue?

[Ehren]

Hi @mafioso. There's currently no UI support for loading a dynamic number of columns columns. For now, you can use the workaround posted earlier. The reason for this being the default is performance: if we know the number of columns ahead of time, parsing/loading can be done more efficiently. If you'd like a way to tweak this behavior via the UI, please submit an idea to the Power BI Ideas site.

Thanks!

Ehren

[v-jiascu-msft · Accepted solution]

Hi @mafioso,

I have reported this issue to the Product Team. The workaround for now is deleting the "Columns=4" part in the Advanced Editor.

Best Regards,

Dale

[v-jiascu-msft]

For the internal reference, the report ID is CRI 67679667.

Best Regards,

Dale