Solved: Re: Refresh and amount of rows

Amok666 · ‎10-05-2017

Plant = 2rows and Released for sourcing is about 50K rows

Hello,

I have filtered for example a dimension to 2 rows however the data refresh is going through all 244 rows? Not a big thing but its rather annoying with larger tables. The dimensin for example is filtered to 50K rows but in the refresh the whole 1,5M rows are running...? Am I doing something wrong?

ImkeF · ‎10-06-2017

The reason is probably that query folding doesn't happen. Check out this article on how what to do:

http://ittichaicham.com/2017/07/validate-performance-improvement-using-query-folding-feature-in-powe...

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

v-chuncz-msft · ‎10-09-2017

@Amok666,

Check if you are using DirectQuery mode.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.