Live data integration of PowerBI

[AbdulMukhtar]

The case:

• server is on Azure, with LAMP stack - MySQL Database. 
• We need to pull the data into PowerBI account every hour

1) since data is in cloud i am not sure whether i need a gateway or not? 

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?

Can some one please suggest me the approach?

Similar case for server in AWS. 

[technolog · Accepted solution]

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/190... 

https://learn.microsoft.com/en-us/power-query/odbc

[abbieabbey6]

Alooma might have some integration option which could help you. They have many options also gathering the data live to one place.

[Anonymous]

Hello @AbdulMukhtar

Even with your server in the cloud, if when you build your PowerBI report you get data from a server (identified by a name), you need a gateway to pull data.

I did the same thing as you (server in the cloud, not MySql but Sql Server) and I had to use a gateway.

for the approach, I think that you'd ensure that the server can be reached with and IP adress or a name. You install the gateway in the server and configured it with your PowerBI account.

In PowerBI, after checking that the gateway is online, you add the data source using the server (don't forget the credential) and it should be good.

At the end, after publishing the report, you can schedule the refresh with the dataset refresh options

Hope it helps

Sebastien

[AbdulMukhtar]

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.

[Anonymous]

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