Power BI for Business Users (Beginners Welcome)

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Slow reports

  • 1.  Slow reports

    Gold Contributor
    Posted Sep 09, 2019 08:55 PM
    Hello everyone,

    I have created simple Power BI report including 4 pages. the model contains 5 tables linked to SQL Server and the whole size not exceeding the 39 MB. Question : This report is slow to navigate and is very difficult to place the cards, move the charts and graphical charts around. It makes the work very hard and unbelievable.

    N.B: my model has relationships both sides. Is this a reason of slow response time?

    Please help.

    Thank you.

    S B
    Data Manager

  • 2.  RE: Slow reports

    Gold Contributor
    Posted Oct 11, 2019 01:21 PM

    HI SB, 

    I am sorry I didn't see this earlier. Start with the Performance ANalyzer in the Power BI Desktop.

    And here are some videos that I have found very informative on debugging slow reports:

    From Guy in a Cube:

    From MBAS:

    Be sure to download DAX Studio to help you debug your DAX. 

    Jessica Jolly
    ALT-Enter, LLC