Forum Discussion
Power BI September 2018 release
Hi VarunPowerBI
You could always find the lastest release on this official site.
You can also check here to verify you are using the latest version.
What's new in the latest Power BI Desktop update?
Additionally, after reviewing lots of update dates over the past periods, i seems there is no fixed date of updating.
Best Regards
Maggie
We are part September 1st week and still no signs of Power BI upgrade. Why can't Microsoft maintain consistency in Product releases and ensure version upgrades happen on time?
This just leads to difficulties in companies where there are streamlined change process for Product upgrades.
I'd rather it be late than broken with a continuous release cycle. If there is a known issue I'd much rather wait a few more days. Most would.
Is there anything specific in the September upgrade that you need VarunPowerBI?
Anonymous We are looking for Direct Query option for MySQL database. It is in the Septemeber 2018 release list ?
Thanks
Aditya
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/
