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

Jsomkul's avatar
Jsomkul
Frequent Visitor
4 years ago

Hi! I have the same issue.

 

I don't understand why I cannot choose to turn off the gateway. For some reports, I don't need a gateway because it's from cloud storage. Once I installed the gateway, it forced me to use the gateway in all reports and all datasets and even in my co-worker's report as well (the data source credentials set up grays out). Is there a way to use the gateway only in one report?