locked
Extreme speed problems when using power query RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have a workbook where I have for example brought in 15 other CSV 's via PQ and merged them in various capacities with a master query. I have broken some out by dimensions for the pivot tables I need in power pivot as well but I often spend half my day waiting for a query to refresh or sometimes it will just flat out refuse to load even a simple 3 column 40 row table to the data model. 

    How can I speed this up? I have tried background refresh and quick load interchangeably, I am afraid to use buffer tables and I am just not sure how to speed up my master query. If this was just power pivot I would make a proper star schema etc but I need to display the results also as a table with all the data from these combined CSV's in addition to a power pivot table. 

    Any suggestions? 

    Monday, November 2, 2020 5:23 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Suggestion: post your code so that we could help you


    • Edited by anthony34 Tuesday, November 3, 2020 5:10 AM
    Monday, November 2, 2020 8:40 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Samizdad-Press,

    without any more details about your specific query like anthony has asked for, we can just point to general recommendations, like this for example: https://www.thebiccountant.com/speedperformance-aspects/ 

    Imke Feldmann - MVP Data Platform (PowerBI) - http://www.TheBIccountant.com 

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful - Thanks!

    Sunday, November 15, 2020 7:52 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Are you using Table.Combine to concatenate the tables?

    Ehren

    Friday, November 20, 2020 12:10 AM