Forum Discussion
Upload a big Query
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
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
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.
1 Reply
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
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.