Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everybody!
I’ve an issue with performance in PBI and when tracing it in DAX Studio I saw lots of queries running and PowerBI Desktop was in standby.
I’ve the latest version of PBIX. October 2018, and I’m experiencing some strange behaviour with lots of DAX queries (hundreds of them!) working in background (tracing in DAX Studio), and affecting the performance of PBI.
Hope you can help me on this.
All those queries are automatic?!, and running repeatedly when I’m not doing anything in power bi desktop.
It seems that each of those queries create a temp table/list of all distinct items of each column from each table with LEN (column) < 100, and i've nothing in canvas to origin those queries. Well I’ve hundreds of columns in dozens of tables in one data model… and I don’t understand what is the goal of this?!
Anyone knows why? There’s any way to stop this?
Exampe: EVALUATE SELECTCOLUMNS(FILTER(VALUES('Movimentos'[TerceiroSede]),LEN('Movimentos'[TerceiroSede])<=100),"valueColumn",'Movimentos'[TerceiroSede])
Once again thanks for your help!
same problem here.. anyone solved?
Please help
Hi everyone,
Try to disbale this optin (Natural Language) in Power BI Desktop
Did you ever figure this out? I am experiencing the same thing.
Hi @JosePintor,
Check the video below regarding the Performance issues o Power BI, it's on the site of SQLBI the creators of the DAX Studio, can give you pointers on how to check what is happening.
https://www.sqlbi.com/tv/my-power-bi-report-is-slow-what-should-i-do/
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |