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
    +16467703026
    ------------------------------


  • 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:
    https://www.youtube.com/watch?v=eABg872TAJU

    From MBAS:
    https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-My-Power-BI-report-is-slow-What-should-I-do/td-p/712567
    https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Designing-for-high-performance-in-Power-BI/td-p/712523

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



    ------------------------------
    Jessica Jolly
    ALT-Enter, LLC
    312/617-9134
    Jessica.Jolly@altentertraining.com
    ------------------------------