Forum Discussion

gwright15's avatar
gwright15
Helper I
5 years ago
Solved

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 gatewa...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    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

gwright15's avatar
gwright15
Helper I
5 years ago

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.