Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
250
Views
Topic starter
I built a series of power pivots from the data model that comes from power query of an excel file and a couple of simple tables in the workbook. All the pivots work fine until I go to refresh, then all they all pretty much blank out. What am I doing wrong?
Posted : 13/01/2018 7:36 pm
Hi Andrew,
Is there an error message or the pivot tables are just showing no data?
When you refresh a power pivot table, the connections are refreshed too, so make sure there is data in the source file.
Posted : 14/01/2018 2:25 am