Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How to refresh a report when excel is used as source?

I am new to POWER BI and require some help in refershing the data. I recently created a dashboard using excel as source for the data. The dashboard works fine, however, if I have to refresh the data ...
Need Help
  • SaritaSenapati's avatar
    SaritaSenapati
    9 years ago

    Hi Anonymous

     

    For change header types – well, if you go to query editor, you will see the column names are hardcoded in the formula bar. Hence, when you change the column header names, power Bi will throw an expression error, as it is not able to find the column present in the formula bar.

     

    To fix this issue, in query editor window, delete changed type under applied steps. Now when you change column header names, the new name will be reflected in power Bi as well. Same behaviour applies for deleted columns.

     

    Let me know if this helps or if you found a different solution.

     

    Regards,

    Sarita

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Sarita,

 

Thanks for your suggestion!!

 

After I removed the "Changed Type" under "Applied Steps" all my changes (addition/deletion/modification of column) is reflecting when I refresh the data. 

 

Regards,

PKR

Pandreoni's avatar
Pandreoni
Frequent Visitor
8 years ago

Thanks for this. Mysteriously it does happen that sometimes my query is refreshed correctly, sometimes not. I tried to use that step, looks like its working.

 

Just a question: if I remove Changed Type and I close / reopen the Query Editor, Changed Type is still in the applied steps. Is that normal? i clicked Apply & Close.