Forum Discussion
Helper IIFiltering a view but it still loads the entire table
I am connecting to an azure sql db and i am filtering a view down to just the relavant data in powerquery.
Let just say i filtered it to 5 row.
when i go to apply changes the report still shows loading the 30k rows in the view.
Which takes quite a while sometimes an hour
is there a reason for this?
Hi abehrmann,
I assume that your query can't be folded to the Azure SQL DB. In such case PowerQuery downloads all data and then does all the transformations. It depends on what you do with your data in your ETL and if it is supported by the data source.
More about that for example on https://exceleratorbi.com.au/how-query-folding-works/ or just search for "Power BI Query Folding" on the internet.
3 Replies
abehrmannThis is what i have started to do to reduce the likeihood that a query will not fold.
Thanks
- Nolock
Resident Rockstar
Hi abehrmann,
I assume that your query can't be folded to the Azure SQL DB. In such case PowerQuery downloads all data and then does all the transformations. It depends on what you do with your data in your ETL and if it is supported by the data source.
More about that for example on https://exceleratorbi.com.au/how-query-folding-works/ or just search for "Power BI Query Folding" on the internet.
