Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

need ideas/help to pull data from Redshift to Power BI in efficient way

Hello Everyone,   we are new to the Power BI tool. we are using high configuration Redshift DWH cluster(OLAP DWH) and Power BI(reporting tool). Power BI Gateway is in the same VPC with the Redshift...
Need Help
Tips and Tricks
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

You may use Amazon Redshift connector to connect data, see more details: Connect to an Amazon Redshift database in Power BI Desktop.

 

In your scenario which has a large data source, recommend you choose DirectQuery mode, while there are some limitations you may considerate: Use DirectQuery in Power BI Desktop. And you may use Incremental refresh which refreshes only data that has changed, see more detail steps: Incremental refresh in Power BI Premium .

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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