Forum Discussion
Excel workbook won't refresh in App Workspace / Excel Online
v-jiascu-msft I haven't managed to solve it
So I guess we can conclude that data refresh (by Power BI) isn't supported when Power BI connects to an Excel Workbook
Hi edwardrmiles,
According to my test, if the workbook has a model, a gateway could be needed for refresh. Does your workbook have a model? What are the data sources of the model if it has one?
BTW, Power BI is a professional software that aims at data modeling, manipulating and sharing. Why not using Power BI?
Best Regards!
Dale
My workbook doesn't have a model. It is just an Excel visualisation of some Power BI data (as the users needs to maniuplate the data in ways not practical in Power BI).
You can replicate the problem by creating a new Excel workbook, then using the 'Connect to Data' option in the Power BI Publisher for Excel Add In. Create a pivot table using some Power BI data then upload (don't import) the workbook to your App Workspace
Hi edwardrmiles,
I tried. But it always said "data refresh not supported". I have tried these below:
1. Connect to report/dataset from excel;
2. The original dataset connects to SQL Server both live and import, Excel workbook.
Did you solve it?
Best Regards!
Dale
v-jiascu-msft I haven't managed to solve it
So I guess we can conclude that data refresh (by Power BI) isn't supported when Power BI connects to an Excel Workbook