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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors