Not able to refresh PowerBI data from Excel

[DekkerNick]

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? 

[GilbertQ]

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]

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. 

[GilbertQ · Accepted solution]

Hi @DekkerNick 

Yeah unfortunately that is not possible currently.

You can create or vote for an idea at https://ideas.powerbi.com