Forum Discussion

Wayde's avatar
Wayde
Regular Visitor
2 years ago

Powerbi Gateway MYSQL Datasource Error

Hi All,   I am hoping someone can provide some assistance or clues as to what may be wrong:   The error message is as below:   Data source error{"error":{"code":"DM_GWPipeline_Gateway_InvalidCo...
Need Help
Wayde's avatar
Wayde
Regular Visitor
2 years ago

Thanks for your input.

Please could you elaborate further on what you're suggesting? 

The server we are connecting to is a vendor provided server. Previously the ODBC connection worked, however, Im not sure what your suggestion entails.

 

Should I install the MariaDB ODBC driver on the PBI Gateway? or Test it on my PC?

 

Thank you.

lbendlin's avatar
lbendlin
Super User
2 years ago

It's your choice - personally I prefer whatever driver gives best performance.  ODBC is not known for speed, but it has other advantages.

  • Wayde's avatar
    Wayde
    Regular Visitor
    2 years ago

    That has not made a difference unforuntately.

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      8.0.28 ?