Forum Discussion

mafioso's avatar
mafioso
Helper II
8 years ago
Solved

Refreshing data in Query Editor doesn't work

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 ...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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.

    Refreshing_data_in_Query_Editor_doesn_t_work

     

    Best Regards,

    Dale

Ehren's avatar
Ehren
Microsoft Employee
8 years ago

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