Upload a big Query

[Anonymous]

Hi 

I'm trying to upload a query to the PBI but getting the message of a run time session (its take for the query to run 30 min apx in sql server). 

Is there a solution for that?

Thanks

[Anonymous · Accepted solution]

Hi  @Anonymous ,

When the amount of data is too large, it will cause slow loading speed.

In sqlserver, you can consider increasing Index to increase retrieval efficiency

https://www.dnsstuff.com/sql-server-optimization-tools

or

Optimize the model in power bi to reduce unnecessary columns and data.

https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization

https://community.powerbi.com/t5/Desktop/Transformations-in-Power-Query-Very-Slow-Performance/td-p/584292

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.