Forum Discussion
Post PatronRefreshing Excel Workbook in Power BI Service
Community SupportHi Razorbx13
You can note the purpose here:
you can’t edit your workbook in Power BI. But if you need to make some changes, you can click Edit, and then choose to edit your workbook in Excel Online or open it in Excel on your computer. Any changes you make are saved to the workbook on OneDrive.
If you'd like to change the filter:
If your Excel workbook file connects to external data sources, or you imported from a local drive, you can setup scheduled refresh to make sure your dataset or report is always up-to-date. In most cases, setting up scheduled refresh is quite easy to do, but going into the details is outside the scope of this article. See Data refresh in Power BI to learn more.
Razorbx13Well I must be doing something wrong. I can see the worksheet in PowerBI and the PowerBI dataset that I connected to in Excel when building the report. And I can Edit in Excel Online. I can do a few editing things (like change a cell color, type something in a cell) basically do anything except for Refreshing the Pivot Table or making any changes whatsoever to the Pivot Table. Else I get the error below. If I attempt to remove or add or adjust the pivot table, error below. Go to Data in the Menu and Refresh Data? Error. That is what I mean as to what is the purpose of the file if I cannot "work, pivot and refresh" the Pivot table or work with the PowerBI dataset I am seeing. In fact, I cannot do anything with the Dataset at all.