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.
Hi,
I have a composite model from a number of SQL databases.
I have a fact table (direct query) and an aggregated fact table (import) from one database.
I have a calendar table (dual mode) from another database.
I'm finding the queries are very slow when drilling down by the calendar table (with measures from the fact table). Is this because of the different data sources?
Regards
Mike
Hi @Anonymous ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
Hi @Anonymous,
Did you write complex measures in your scenario? You can use DAX Studio to run traces against your measures in your data model to find the issue
https://daxstudio.codeplex.com/
See this blog as a start point of how to use this feature
Quite often slow queries often relate to poorly written measures (I used to struggle with this a lot when I first started using Power BI).
Use this tool to investigate what measure is causing you issues and maybe post that query on here if you can't work out how to make the query more efficient after some googling.
Regards,
Frank
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |