Forum Discussion

ATREZISE's avatar
ATREZISE
Helper I
6 years ago
Solved

Query Editor Performance

Hi All   I have been using Power BI for a while now but am becoming increasingly frustrated with the performance issues whilst building queries using the query editor.   Admittedly some of my rep...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi ATREZISE ,

Unfortunately, there is not a option that can stop always refreshing. You could try to use Query Folding to improve performance based on your actual scenario. 

Here are some blogs that you could reference.

Query Folding in Power Query to Improve Performance

How Query Folding Works

Power BI - Checking Query Folding with View Native Query

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ATREZISE's avatar
ATREZISE
Helper I
6 years ago

Hi

 

Thank you for your quick response.

 

I've done a little research on Query Folding - it appears to be pretty early into it's journey.

 

BTW I am a 'casual' PBI user (not advanced). I can do a little DAX coding and data modelling but I am not an expert in this area so for something like Query Folding to work for the masses it has to be made simple and straightforward.

 

The first problem I appear to have is that none of my data sources seem to support it - I am using ODATA and SSAS Data Cubes (via Import)...after I connect to these sources the 'Native Query' is option disabled (before I do any transformations).

 

So I suppose (unless I am missing something) this will not work for me?

 

Thanks