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.

ovidiubaciu's avatar
ovidiubaciu
Regular Visitor
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.