Dax Queries "always" running in background - Power BI

[JosePintor]

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!

[leokarpa]

same problem here.. anyone solved? 

Please help

[JosePintor]

Hi everyone,

Try to disbale this optin (Natural Language) in Power BI Desktop

[Anonymous]

Did you ever figure this out? I am experiencing the same thing.

[MFelix]

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