•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power BI Semantic model accessed from Excel causes error when collapsing a row or column hierarchy in the pivot table.
I've noticed that a semantic model we have is resulting in an error when collapsing a row or column hierarchy, like for example collapsing a month and day hierarchy to just month. This error seems to occur with all of our dimensions not just Time, but does not occur at all when the model is accessed from Power BI. Does anyone know what could be causing this issue?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#row zero
#rows.com
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#real-time data collaboration
#financial modeling with spreadsheets
#real-time collaboration
#Power BI
#semantic model
#Excel
#pivot table
#error
#row hierarchy
#column hierarchy
#dimensions
#collapsing
#Time dimension