Pivot Table Linked to Power BI Dataset has relationship problems

Power BI Data Model
1

I have built a data model using Power BI Desktop.

The data model has a matrix visual. I’m using the technique that Enterprise DNA taught for the display of financials (this is for inventory, but uses the same concept).

The matrix works correctly in Power BI (see below)

image
image886×281 16.3 KB

However, I need for the visual to be in Excel.
I published the Power BI model to the PowerBI.com and then opened an excel file and inserted a pivot table that is connected to the Power BI model.

When I put the fields in the pivot table so it should recreate the Power BI matrix visual, the pivot isn’t working (it looks like a relationship problem?).

image
image776×286 9.11 KB

Any idea why the Excel pivot table isn’t working?

Bill

1 Like
2

I don’t know why this problem happened, but the solution was simple.

Instead of opening Excel and inserting a pivot table sourced from Power BI, I went into Power BI and exported for Analyze in Excel. When I opened the downloaded excel file, everything worked perfectly.

2 Likes