Forum Discussion

ovidiubaciu's avatar
ovidiubaciu
Regular Visitor
3 years ago
Solved

Unable to select Power BI hierarchy in Excel PivotTable

My Power BI report uses an import-mode connection to an Azure SQL Database. In the report, I created a 2-level hierarchy. I published the report to Power BI Service (PPU Trial). When analyzing the p...
Need Help
  • ovidiubaciu's avatar
    ovidiubaciu
    3 years ago

    I might have found a workaround for this. I renamed a bunch of stuff in Power BI (the table, the hierarchy, and the levels/dimensions of the hierarchy). I then refreshed the data source in Excel, and now I was able to select the hierarchy in my PivotTable.

    However, I still don't know why the problem occurred in the first place. I even tried renaming everything back to its original name, but the issue does not reproduce.

wannabwhiz's avatar
wannabwhiz
New Member
1 year ago

Easier solution:

- Open the model in Power BI Desktop and manually refresh the data.
- After doing this, republish the dataset.
- Reconnect to the semantic model from Excel and insert the pivot table again.

sbelskiy's avatar
sbelskiy
New Member
1 year ago

- Open the model in Power BI Desktop and manually refresh the data.
- After doing this, republish the dataset.

 

This is enough in many cases to fix the issue