Forum Discussion
Advocate IAuto-refresh for exported data in Excel even separate items in multiple sheets
Hi RichardGAO
Unfortuntely as soon as you export data from a visual it creates a disconnected data set that is not longer related to your original dataset. So I do not think it will work for your situation.
I would suggest extracting the data using the Excel method, as you can always use Cube Formula's to get the data in the structure you require. Which will be connected to the data.
Super UserHi RichardGAO
What you could do, is to install the Power BI Publisher for Excel.
https://powerbi.microsoft.com/en-us/excel-dashboard-publisher/
This will allow you to open Excel and then connect Directly to your Power BI dataset in the cloud. And then you can use all the standard functionality that is in Excel, such as Refreshing the data and using Pivot tables.
Advocate IThank you GilbertQ! However, this is not my scenarion.
I am using 'export' functionality to export data from an online PBI report to an local excel file, then expecting any data change (For example, the online dataset auto-regular-refresing retrieved fresh data from data source to the dataset/reports) can also be refreshed/pushed to the excel file.
The PowerBI Publisher for Excel you introduced is seemingly same to the "Analyze in Excel" menu/functionlauity of online PBI reports that create pivot or chart in excel using the PBI data as data source. But my scenarion is directly using/presenting existing report's data(items) in excel(I don't create pivot or chart in excel file).
Thanks!
- GilbertQ
Hi RichardGAO
Unfortuntely as soon as you export data from a visual it creates a disconnected data set that is not longer related to your original dataset. So I do not think it will work for your situation.
I would suggest extracting the data using the Excel method, as you can always use Cube Formula's to get the data in the structure you require. Which will be connected to the data.