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.

lbendlin's avatar
lbendlin
Super User
1 year ago

Use DAX Studio to examine the query that is created each time. What's the cardinality of the hierarchy levels?

  • JustinDoh1's avatar
    JustinDoh1
    Post Prodigy
    1 year ago

    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.

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      This should get you going

       

      DAX Query Plans

       

      Look out for excessive number of records. Those indicate likely full cartesians, stuff that usually leads to exceeding the resources.