cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gwright15
Helper I
Helper I

Gateway

Good morning

 

We are running a gateway to access a local data source (mysql database).  We also had data on an amazon redshift server.  When have set up the gateway, it forces me to use the gateway to access the online redshift server.  Is this normal behaviour?  Whilst it has worked fine, it puts more stress on our own servers.

 

Many thanks

Graeme

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @gwright15 

Do you combine queries (e.g. merge/append queries) which are pulled from local and cloud data sources? If so, it will need an on-premises data gateway to deal with the combined queries. Reference: Merge or append on-premises and cloud data sources - Power BI | Microsoft Docs

 

If you don't combine local and cloud data sources, although it may show red X beside the cloud data source (because you don't add it to the gateway), it is still possible to refresh the dataset correctly. You can have a try.

 

Regards,
Community Support Team _ Jing

View solution in original post

4 REPLIES 4
v-jingzhang
Community Support
Community Support

Hi @gwright15 

Do you combine queries (e.g. merge/append queries) which are pulled from local and cloud data sources? If so, it will need an on-premises data gateway to deal with the combined queries. Reference: Merge or append on-premises and cloud data sources - Power BI | Microsoft Docs

 

If you don't combine local and cloud data sources, although it may show red X beside the cloud data source (because you don't add it to the gateway), it is still possible to refresh the dataset correctly. You can have a try.

 

Regards,
Community Support Team _ Jing

View solution in original post

gwright15
Helper I
Helper I

Thank you.  We have another data file, which is just redshift and excel data, and this works fine without the gateway.

 

The issue seems to be when the local and redshift data is being pulled, it makes both use the data gateway.  I would have though the local data would be pulled via the gateway, and the redshift via the native connection.

nickyvv
Super User I
Super User I

Hi @gwright15,

 

although this is a pretty old article, it does explain that a gateway is not needed:

https://powerbi.microsoft.com/en-us/blog/announcing-support-for-amazon-redshift-reports-in-the-power...

Did you use Import or DirectQuery?



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


Thank you so much.  There is a merge which must be stopping it.  I'll try and do the merge in the data warehouse rather than BI and see if that resolves.  Thank you!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors