Forum Discussion

eloymora's avatar
eloymora
Frequent Visitor
6 years ago
Solved

Composite Model (Redshift) & Data Gateway on Power BI Service

Hello   I've got a composite model on Power BI Desktop which has Amazon Redshift tables as the main data source and some tables from local data sources like spreadsheets or csv files.   If I publ...
Need Help
Smile's avatar
Smile
Frequent Visitor
3 years ago

Hi, 

 

I've got a composite model on Power BI Desktop which has Amazon Redshift tables as the main data source and some tables from data sources like excel files that are all on the Sharepoint. 

I had the gateway installed for Amazon Redshift as otherwise it would not allow us to schedule the report for auto-refresh.

 

I've noticed that the gateway works fine when the model only using the Redshift sources. However, as soon as another data source (on the Sharepoint) is added, it fails to refresh the data set with the error message saying the gateway does not allow cloud datasource refresh. 

 

Is there a way to have this composite model running on Power BI Service with the gateway for Amazon Redshift installed?

 

Thank you!