Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
AbdulMukhtar
Frequent Visitor

Live data integration of PowerBI

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. 

 

1 ACCEPTED SOLUTION
technolog
Super User
Super User

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

View solution in original post

5 REPLIES 5
technolog
Super User
Super User

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
New Member

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

 

Anonymous
Not applicable

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

 

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
Not applicable

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Top Solution Authors
Top Kudoed Authors