Forum Discussion

mimitan's avatar
mimitan
Regular Visitor
5 years ago
Solved

Refreshing PowerBI data from excel with multiple sheets combined thru Power Query Editor

Hi everyone,

 

Brief background, I consolidated and cleaned multiple sheets from 1 excel file through Power Query. My question is if I updated each of these sheets in excel file, do I need to repeat the same process of consolidating them and cleaning the data through Power Query to reflect the updates I did in the excel file or is it safe to just refresh data from the fields tab (in the right pane)? 

 

 

Please help 😞 Thank you.

Need Help
  • nvprasad's avatar
    nvprasad
    5 years ago

    Hi,

     

    You need not do it manually every time. Just click on the "refresh" button on the home page. If you have a gateway established then go to PowerBI datasets within the workspace and click on the "refresh" icon.

     

    Appreciate a Kudos! 🙂
    If this helps and resolves the issue, please mark it as a Solution! 🙂

    Regards,
    N V Durga Prasad

1 Reply

  • nvprasad's avatar
    nvprasad
    Solution Sage
    5 years ago

    Hi,

     

    You need not do it manually every time. Just click on the "refresh" button on the home page. If you have a gateway established then go to PowerBI datasets within the workspace and click on the "refresh" icon.

     

    Appreciate a Kudos! 🙂
    If this helps and resolves the issue, please mark it as a Solution! 🙂

    Regards,
    N V Durga Prasad