cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Dax Queries "always" running in background - Power BI

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])

 

Screenshot.png

 

Once again thanks for your help!

4 REPLIES 4
Highlighted
Super User V
Super User V

Re: Dax Queries "always" running in background - Power BI

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Advocate I
Advocate I

Re: Dax Queries "always" running in background - Power BI

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

Highlighted
Frequent Visitor

Re: Dax Queries "always" running in background - Power BI

same problem here.. anyone solved? 

Please help

Highlighted
Frequent Visitor

Re: Dax Queries "always" running in background - Power BI

Hi everyone,

 

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

Disable Natural language.PNG

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors