Forum Discussion

DekkerNick's avatar
DekkerNick
Frequent Visitor
2 years ago
Solved

Not able to refresh PowerBI data from Excel

Hi all,

 

I have created an Excel-file (sorry for that, but the directors really want to have a particular file still in Excel) including Pivot Tables. 

The source I use, is a dataset from PowerBI. However, when I click on data refresh in Excel, it does not seem to work. 

Moreover, when I first click on data refresh in PowerBI, and thereafter, in Excel, the data is yet refreshed. 

 

I would like to have a opportunity to trigger a data refresh of the PowerBI dataset from the Excel-file. 

Can anyone help me with this? 

Dataflow

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi DekkerNick 

     

    You have to make sure that your Power BI dataset is being updated via a scheduled refresh to get the new data. If that is happening then when you go into the Excel file and refresh the file it will get the new data from the Power BI dataset?

    • DekkerNick's avatar
      DekkerNick
      Frequent Visitor
      2 years ago

      Hi GilbertQ , that is indeed the case. When the PowerBI report has been refreshed, and thereafter, I refresh in Excel, this data in Excel is also refreshed. However, I was hoping that the step including refresh data in PowerBI (even with a scheduler) was not necessary. Moreover, to trigger refreshing the Excel and PowerBI data from Excel.