Forum Discussion

VarunPowerBI's avatar
VarunPowerBI
Regular Visitor
8 years ago

Power BI September 2018 release

Could i know of version 2.62 of Power BI desktop for September 2018 will be released on time, just as last month.  Can i know if there are any possible delays in release time so to plan ahead.
Need Help
rangineniaditya's avatar
rangineniaditya
Frequent Visitor
8 years ago

Anonymous We are looking for Direct Query option for MySQL database. It is in the Septemeber 2018 release list ?

 

Thanks 

Aditya

Chihiro's avatar
Chihiro
Icon for Solution Sage rankSolution Sage
8 years ago

rangineniaditya

 

While PowerBI doesn't support Direct Query for MySQL, you can use workaround. Though I wouldn't recommend it for large data set.

 

Ex:

1. Set up MSSQL (Standard or better is preferred but you can get away with Express) 2012 or later

2. This can be set up in Gateway server or another server that Gateway server can communicate with.

3. Set up Linked Server to MySQL using ODBC driver

4. Bring in data as View/Table using OPENQUERY() from MySQL to MSSQL

5. Set up Direct Query to MSSQL View/Table

 

Also, I'm not familiar with the process but looks like you should be able to create custom connector to enable DirectQuery via ODBC driver.

https://powerbi.microsoft.com/en-us/blog/data-connectors-developer-preview/