Forum Discussion

JustinDoh1's avatar
JustinDoh1
Post Prodigy
1 year ago
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...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    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.

JustinDoh1's avatar
JustinDoh1
Post Prodigy
1 year ago

lbendlin  

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. 

  • JustinDoh1's avatar
    JustinDoh1
    Post Prodigy
    1 year ago

    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. 

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      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.

      • JustinDoh1's avatar
        JustinDoh1
        Post Prodigy
        1 year ago

        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))?