Forum Discussion

1320Data's avatar
1320Data
Frequent Visitor
3 years ago

Loading Data from PowerQuery to PowerBI takes ages

Hi all,

 

I have a excel file where there are 42k + rows and am trying to use function to generate tables. I could not load back into Power BI it keeps loading loading for more than 30 mins. 

 

Do you know a way to speed up the performance.

 

Thanks 

Need Help

1 Reply

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    Please go to the Advanced Editor and share the M code for your Invoked Function(s), so we can see what might be causing the slow performance.

     

    Pat