Azure SQL Data Warehouse & Gateway Sources simultaneously

[Yitzach]

I find I'm unable to refresh datasets in Power BI service that have a source in Azure and a source in my gateway.

I've tried adding Azure to the gateway but it doesn't seem to work.

I'm at a loss as to how I can get these datasources to update with one source being my Azure SQL Data Warehouse and the other(s) being linked in through my Gateway.

Please advise.

Processing error:

There is no available gateway.

[GilbertQ]

Hi there, currently this is a limitation with the On-Premise Data Gateway.

I am fairly certain that this is something that they are working on resolving.

[Anonymous]

@GilbertQis right and this is an issue i'm having to work around myself.  I have gone the other direction and have implemented into my data warehouse a refresh to grab the data out of the other sources and put everything into Azure.  This allows me to dodge the gateway for Power BI in those reports.  I'm only a few months into our warehousing project, so i'm yet to find a scenario in our business where this doesn't work.