Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
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
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?
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
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.
Hi @gwright15,
although this is a pretty old article, it does explain that a gateway is not needed:
Did you use Import or DirectQuery?
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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
30 | |
19 | |
12 | |
8 |
User | Count |
---|---|
51 | |
36 | |
29 | |
14 | |
12 |