Forum Discussion
Live data integration of PowerBI
1) since data is in cloud i am not sure whether i need a gateway or not?
it depends on the connection option
2) I know I can create live connection with Azure SQL database but not sure whether we can do the same with the above set up?
it's possible, but it can't be done the easy way
a) CData's DSN/ODBC - https://www.cdata.com/drivers/odata/order/odbc/#desktop
b) MySQL ODBC Direct Query Custom Connector -
https://community.fabric.microsoft.com/t5/Developer/MySQL-ODBC-Direct-Query-Custom-Connector/m-p/1903899
Hi,
Thanks for the resposne.
Where i need to install personal gateway, whether on Azure server (Because my source is on Azure Server) or on premises server.
Hello,
The gateway should be installed on the server which can access your datasource.
So if your server is on Azure, I guess, you have to install the gateway on the auzre server.
Sebastien