Forum

Pivot Table Breaks ...
 
Notifications
Clear all

Pivot Table Breaks on Refresh of Power Query

2 Posts
2 Users
0 Reactions
250 Views
(@a_dunleavey)
Posts: 1
New Member
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
(@catalinb)
Posts: 1937
Member Admin
 

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
Share: