Power BI Exchange

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

Slow "Apply query changes"

  • 1.  Slow "Apply query changes"

    Posted 22 days ago
    Greetings PowerBI UG!  I have imported list data from a SharePoint site, and done some initial cleaning to that query in the query editor. The query has a LOT of columns which I want to separate into separate fact and dimension tables; I referenced the initial query as a starting point for the fact (1) and dimension (3) tables....for some reason it is taking forever (in excess of 10 minutes) for any of the new tables to 'apply.' Does anyone have any thoughts as to what might be causing the extremely slow performance? Is my approach flawed (wouldn't be the first time)? Thanks!

    ------------------------------
    Paul
    ------------------------------
    Conference-PBI_200x200


  • 2.  RE: Slow "Apply query changes"

    Top Contributor
    Posted 22 days ago
    Hi Paul !

    The performance problem you might be experiencing is related to your SP Site, seems like your SP List has too many columns which is making extremely difficult to load the schema.

    Regards,

    ------------------------------
    Hasham Bin Niaz
    Director Data & Analytics
    Karachi, Pakistan
    ------------------------------

    Conference-PBI_200x200


  • 3.  RE: Slow "Apply query changes"

    Posted 22 days ago
    Thanks! I was wondering that myself...if that's the case, I'll have to deal with the decreased performance as a different group owns the SP site.

    ------------------------------
    Paul Petsu
    4435348193
    ------------------------------

    Conference-PBI_200x200


  • 4.  RE: Slow "Apply query changes"

    Top Contributor
    Posted 22 days ago
    Hi Paul !

    Did you know the #of columns in your original SP List ?

    You can ask your SP Site people to create a view which might be only selected columns form original SP List to reduce the loading time.

    For development purpose i would like you to do it in some demo tenant where you have lesser data & simplified view so you can go through the development & than later redirect your query string to production SP Site.

    Regards,​

    ------------------------------
    Hasham Bin Niaz
    Director Data & Analytics
    Karachi, Pakistan
    ------------------------------

    Conference-PBI_200x200


  • 5.  RE: Slow "Apply query changes"

    Posted 21 days ago
    As a few general rules to follow:

    • Bring into Power BI the minimum number of columns that you actually need
    • If you then need to remove columns, remove them early (I prefer using the Advanced Editor but that's just me)
    • If a table isn't required in your dashboard make sure it's marked as such


    ------------------------------
    Paul Jennett
    Change Manager
    Milton Keynes
    ------------------------------

    Conference-PBI_200x200