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.

teegreazy's avatar
teegreazy
Frequent Visitor
2 years ago

I experienced the same error. I created a semantic model in PowerBI. Within the model I created 3 hierarchies. When I connect to the model in Excel and try to use the hierarchy dimensions I get the following error;

 Cannot query the '<ccon>Product</ccon>'[<ccon>Product Hierarchy</ccon>] hierarchy because it is not processed. Please refresh or recalculate the table '<ccon>Product</ccon>'.