Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a star-schema model, it works fine, until I put a field from one specific dimension.
Then it thinks for 10 or more minutes before showing a matrix.
Nothing special about this dimension, no measures treat it differently, it is not large.
Any ideas?
Solved! Go to Solution.
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.
Proud to be a Super User!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |