Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
We have an on-premise gateway and it works very well for all of our service reports but I now need to add Azure Database data to some of these reports.
Is there any option in the service to have two gateways or do i need to bring the Azure data into our local data warehouse and then use the on-premise gateway?
Any advice would be awesome, thank you 🙂
Mattie
Solved! Go to Solution.
Hi @MattieG72MP,
I tested it successfully with import mode to local SQL DB and Azure SQL DB. Please try it out.
Best Regards,
Dale
I dont understand the resolution on this. Im having the same requirement. I have an on premise gateway that Im merging data from a local SQL db and an Azure DB. My current gateway refreshes every day but I dont see an option to add the Azure DB to the gateway. Do you have to dump the Azure DB to local tables then use that table in the gateway? If so how is that done.
Hi @MattieG72MP,
You can use the Azure database directly. Is it a Azure SQL Server Database? You can try it out and post the issues you have.
Best Regards,
Dale
Hi All
Basically what I am trying to achive in the service is having a report that pulls data from the on-premise gateway and also from Azure but as far as i can see there is no way of setting up the
dataset subscription to come from an on-premise gateway and a direct connection to Azure?
Thanks
Mattie
Hi @MattieG72MP,
I tested it successfully with import mode to local SQL DB and Azure SQL DB. Please try it out.
Best Regards,
Dale
Hi @MattieG72MP,
Could you please mark the proper answer as solution?
Best Regards!
Dale
Are you using Personal data gateway or Enterprise?
Hi,
Yes it is an enterprise gateway 🙂
Mattie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.