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 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!