Forum Discussion
Solved
Perfomance issue while using Bookmark in Power BI Service
I am having a performance issue while I am using Bookmark (especially when I try running the report in PowerBI service). This is related to my previous post. I have four hierarchies of data t...
Did you watch the "How to optimize your DAX queries" videos? They go through the process in detail, and show you alternative code that pre-filters your data more efficiently. Reducing cardinality as early as possible is the key to success.
lbendlin Thank you for help.
- I am not sure how to 'examine the query that is created each time'?
I have a SQL View and all four hierarchies come from same table.
- How do I find the "cardinality of the hierarchy levels"? Sorry. I am new to this concept.
Thanks.
This should get you going
Look out for excessive number of records. Those indicate likely full cartesians, stuff that usually leads to exceeding the resources.