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 with a csv file it doesn't. Do you have any ideas how to solve this issue?

  • 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

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    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

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

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

       

      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