cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abehrmann Regular Visitor
Regular Visitor

Filtering 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?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Filtering a view but it still loads the entire table

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.

View solution in original post

Highlighted
Geradav Regular Visitor
Regular Visitor

Re: Filtering a view but it still loads the entire table

Hi @abehrmann,

 

When querying an Azure SQL Database, have you tried implementing a SQL statement at the connection level to apply your filter before it goes into Power Query?

This could greatly improve the performance

Annotation 2019-08-02 222848.jpg

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Filtering a view but it still loads the entire table

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.

View solution in original post

Highlighted
Geradav Regular Visitor
Regular Visitor

Re: Filtering a view but it still loads the entire table

Hi @abehrmann,

 

When querying an Azure SQL Database, have you tried implementing a SQL statement at the connection level to apply your filter before it goes into Power Query?

This could greatly improve the performance

Annotation 2019-08-02 222848.jpg

View solution in original post

abehrmann Regular Visitor
Regular Visitor

Re: Filtering a view but it still loads the entire table

This is what i have started to do to reduce the likeihood that a query will not fold. 

 

Thanks

 

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)