Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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.
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |