Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Reduce the Number of Records Pouring In

Hi: Through an ODBC connection, we chose one view in our database from which to pull records into Power BI.  But, it's a lot.  We're talking millions upon millions. We tried clicking the "Transform...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

SQL ODBC data source.

Filter = dropdown from column heading.

I have never herd of Query Folding.  What is it?

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

For "Query Folding", please refer to these documents:

Query folding guidance in Power BI Desktop;
Power Query query folding.

 

In addition, how about using parameter to filter your data before loading the data into Power Query?

Reference:

Using parameters;

Deep Dive into Query Parameters and Power BI Templates;

Dynamic Power BI reports using Parameters.

 

 

Best Regards,

Icey

 

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