Slow Applying Query Changes

[Anonymous]

Hello,

I have a data model that contains 3 tables, 1 fact table and 2 dimension table. I have applied the basic relationship using one to many. I have filtered the needed requirements and columns as well. The thing is when i click close and apply, the apply query changes is taking too long to load the data. It's really slow like it would take 1-2 hours to finish loading the model for 1 table that i have changed.

Is there a way to speed up things? The data source is SQL (through OLEDB conection), 2 local excel files as reference.

Thanks for the help..

[v-jingzhang]

Hi @Anonymous 

What is the data source of this table? If it is SQL Server, you could try using the standard SQL Server connector instead of the OLEDB connector. This may improve the performance. 

Reference: Best practices when working with Power Query | Microsoft Docs

And you could use Sql Server Profiler to find out the duration time of a query operation at the database side. In this way, you could further find out whether query time is too long or the proceeding operations takes too much time.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[edhans]

We'd need to see the M code for the table you have transformed. If it is SQL Server, hopefully most of the transformations are folding. Please use the </> code box on the menu bar (hit the ... button to see it) so the code is a bit more readable.

[gdarakji]

Is the dataset too large? How many columns do you have in the fact table and the dimension tables?