Forum Discussion

rafaelmorenopbi's avatar
rafaelmorenopbi
New Member
4 years ago

Incremental refresh and query folding with AWS redshift as data source

Hi   I have a dataset importing data from a Data Warehouse. So far we operate in a full refresh mode, and I was willing to change to incremental refresh. However I read the documentation and it sta...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi rafaelmorenopbi ,

Most data sources that have the concept of a query language support query folding. These data sources can include relational databases, OData feeds (including SharePoint lists), Exchange, and Active Directory. However, data sources like flat files, blobs, and web typically do not.

In addition, in the Power Query Editor window, it is possible to determine when a Power Query query can be folded. In the Query Settings pane, when you right-click the last applied step, if the View Native Query option is enabled (not greyed out), then the query can be folded.

If the option is greyed out, maybe you could change another data source which supports query folding.

 

I have found a similar post, please refer to the following document to see if it helps you.

https://community.powerbi.com/t5/Service/Incremental-refresh-with-Amazon-Redshift/m-p/1925887/highlight/true

  • use the ODBC connection

https://www.fourmoo.com/2019/08/20/using-azure-analysis-services-to-connect-via-an-odbc-source-redshift/

 

Best Regards

Community Support Team _ Polly

 

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