Forum Discussion
Bad performance on a specific dimension only
I think I've found a reason:
My model is in SSAS, PowerBI is just a viewer with Live Connection.
So in SSAS I had a relationship based on different data types - text and decimal.
It's not very clear what you are saying, please provide more information about the field from the dimension.
Matrix's can be performance heavy but it depends on what you are putting in it. How many rows, what is the relationshi based on for this dimension. Is it a text field, is it a calculated field. Please provide the full details.
The best way to understand what is happening is to run performance analyzer and then run that query in dax studio.
I think I've found a reason:
My model is in SSAS, PowerBI is just a viewer with Live Connection.
So in SSAS I had a relationship based on different data types - text and decimal.