Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
Solved! Go to Solution.
Hi @DekkerNick
Yeah unfortunately that is not possible currently.
You can create or vote for an idea at https://ideas.powerbi.com
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?
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.
Hi @DekkerNick
Yeah unfortunately that is not possible currently.
You can create or vote for an idea at https://ideas.powerbi.com
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
28 | |
26 | |
23 | |
22 | |
18 |
User | Count |
---|---|
52 | |
34 | |
28 | |
24 | |
21 |