Forum Discussion
Improve Performance
Hi all, I`ve been using PBI for around 3 years but learned mostly online, so still learning about best practices. I`m having a small issue because I`m pulling raw data from a server that I have r...
Hi Anonymous ,
If your data source is something like SQL, you can try contacting someone with editing rights to the data source to perform filtering and transformations at the source using a native database query language such as SQL. This will greatly reduce the load pressure on Power BI.
With regard to DAX, I recommend that you download DAX Studio to monitor the timestamps used by DAX statements as a way to find the DAX statements that are causing poor performance and try to modify them.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.