Forum Discussion
Perfomance issue while using Bookmark in Power BI Service
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.
I tried using DAX studio and ran the query after watching few YouTubes, but I am not sure how to make the the performance better.
Also, how do I go about fixing/evaluating the "cardinality of the hierarchy levels" ?
Thanks.
lbendlin Just want to follow up on my questions:
I tried using DAX studio and ran the query after watching few YouTubes, but I am not sure how to make the the performance better.
Also, how do I go about fixing/evaluating the "cardinality of the hierarchy levels" ?
Thanks.
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 I have a question. Does Bookmark's report have any issue with performance (meaning if the query comes from Bookmark, is it usually slower than other visual (not on Bookmark))?
The answer is a definite maybe. If your bookmark calls up a poorly behaving visual and/or a bad filter combination then of course it will have an impact.
Bookmarks are only memories - they record your meta data choice at a point in time. They do neither participate in the rendering nor in the caching.