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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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? 

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/

    • KrisW's avatar
      KrisW
      Icon for Helper I rankHelper I
      8 years ago

      I am testing the PDF Import/Connector & have already found minor issues. Who/How/Where do I report?

       

      IN BRIEF - I have "sample data" G/L Ledger 51 pages. PBI is not bringing in column headers which is not a big deal, but in skipping the headers it is merging any data where there is only 1 space between columns. EXAMPLE: PERIOD SOURCE of 1 PJ became 1PJ & ACCOUNT_NUM ACCOUNT_DESC of 21200 TRADE COLLECTORS became 21200TRADE COLLECTORS - these 2 are easy enough to "split columns" to fix.

      HOWEVER, AMOUNT DESCRIPTION were also merged so instead of -409.09 Pre-conversion purchase, I have -409.09Pre-conversion purchase. There is not a decimal in every amount & the amount total digits can vary. While it is highly unlikely that our company will connect to PDFs on a regular basis, we feel that this is an important feature.