Forum Discussion
SandwichNo1
Jun 12, 2023Copper Contributor
Power query excel web refresh issues
Hi, I have built an excel file in excel desktop app which uses power query and set up a power pivot using the data I have imported. I know when refreshing power query online the power query inputs ne...
SergeiBaklan
Jun 13, 2023MVP
As variant, creating PivotTable or loading the query on desktop you added data to data model. Excel for web doesn't work with it. Please check on desktop your Power Pivot window is empty.
SandwichNo1
Jun 14, 2023Copper Contributor
thanks for getting back to me. So have I got to rebuild the pivot table in excel web instead in order for it to then refresh? Thanks
- SergeiBaklanJun 14, 2023MVP
You need to use cached PivotTable, not one which is based on data model.
- SandwichNo1Jun 14, 2023Copper ContributorAh ok I will have a look at that then. Thanks for your help, much appreciated. Will be great when excel web has same functionality as the desktop. Cheers
- SergeiBaklanJun 14, 2023MVP
Glad to help. Again, that was only my guess what's the reason, it could be something else.