cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
eloymora Frequent Visitor
Frequent Visitor

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 publish the model to Power BI Service with just the Redshift sources, a data gateway is not required. However, as soon as I add some other data sources (e.g. a spreadsheet), I need to have a data gateway running for the Power BI service to work.

Is there a way to avoid having to install a data gateway and have this composite model running on Power BI Service?

 

With thanks and regards
Eloy

1 ACCEPTED SOLUTION

Accepted Solutions
Icey Super Contributor
Super Contributor

Re: dfsComposite Model (Redshift) & Data Gateway on Power BI Service

Hi @eloymora ,

 

You can upload your spreadsheets or csv files to OneDrive for Business Online or SharePoint Online.

 

Best Regards,
Icey

 

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

View solution in original post

2 REPLIES 2
Icey Super Contributor
Super Contributor

Re: dfsComposite Model (Redshift) & Data Gateway on Power BI Service

Hi @eloymora ,

 

You can upload your spreadsheets or csv files to OneDrive for Business Online or SharePoint Online.

 

Best Regards,
Icey

 

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

View solution in original post

eloymora Frequent Visitor
Frequent Visitor

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

Thank you, @Icey . I've just tried the Sharepoint option and it works. There is no need to install a data gateway.

 

Kind regards

Eloy

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 68 members 977 guests
Please welcome our newest community members: