cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
creynolds
Helper V
Helper V

MySql Data Source

I created a report in PowerBI Desktop, connecting to a 3rd party MySQL database.   How can I keep a continuous connection so the data can stay up-to-date?   I understand the PBI Desktop can not use DirectQuery.    If I publish the report to PBI Online, can I create a live connection to MySQL or schedule refreshes?

1 ACCEPTED SOLUTION
collinq
Super User
Super User

Hi @creynolds ,

 

I would like to clarify that Power BI Desktop does use DirectQuery.  To get real time data in the Service, you will need to have the appropriate license and the appropriate setup.  You can find more about that here:

Real-time streaming in Power BI - Power BI | Microsoft Docs

 

Does that help you out?

 

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

1 REPLY 1
collinq
Super User
Super User

Hi @creynolds ,

 

I would like to clarify that Power BI Desktop does use DirectQuery.  To get real time data in the Service, you will need to have the appropriate license and the appropriate setup.  You can find more about that here:

Real-time streaming in Power BI - Power BI | Microsoft Docs

 

Does that help you out?

 

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!