search

mariadb-corporation / mariadb-powerbi

Power BI DirectQuery Connector
https://mariadb.com
3 stars 1 forks source link

Help with MariaDB Direct Query Adapter for Microsoft Power BI #6

Closed Scotto13 closed 3 years ago

Scotto13 commented 3 years ago

I have tried the MariaDB connector on my pc and it works great.
Can I please get directions on how to install the adapter on my OnPremise Gateway in order to build reports on my PowerBI desktop and publish them to the gateway?

I installed the connection to my MySQL db on the Gateway but I don't know how to build reports (on PBI desktop) using that connection. Any help is greatly appreciated.

Thank you, Scott Williams

ilyagithub1 commented 3 years ago

Hello Scott,

Thanks for posting a good question.

Steps to install and use MariaDB Power BI Connector with Power BI On-premises Data Gateway:

  1. (Optional - skip if the ODBC driver is already installed) Download and install MariaDB ODBC Driver v3.1.7 or later.
  2. Download MariaDB Power BI Connector from mariadb.com
  3. Unpack the downloaded MariaDB Power BI Connector package.
  4. Copy the MEZ file to the Gateway's Custom data connectors directory on the target computer.
    1. To find the destination directory path, open One-premises data gateway configuration application, tab Connectors (see the screenshot). Custom data connectors
    2. In Standard Mode the path should look like this - copy the MEZ file here: 
      C:\Users\PBIEgwService\Documents\Power BI Desktop\Custom Connectors
    3. After the file is copied to the location above the Custom data connectors screen should update shortly (in a few seconds usually). MariaDBCustomConnectorInstalled

  5. Set up a MariaDB data source in Power BI Online:

    1. In a browser navigate to Power BI Online app.powerbi.com

    2. In Power BI Online in the upper right corner click Settings > Manage gateways This should open the GATEWAY CLUSTERS page.

    3. Make sure you see your gateway in the list. If you don't you need to troubleshoot the gateway. Gateways

    4. Click ADD DATA SOURCE.

    5. In the Data Source Type drop-down list select MariaDB data source. AddDataSource

    6. In the MariaDB data source field provide a value that matches exactly to the data source value as visible in the Data source settings dialog in Power BI Desktop.

      1. Note that the data source value may optionally contain the server port and/or database name, e.g. myserver:3306 or myserver;flights or myserver:3306;flights.
      2. Double-check that the MariaDB data source values match in Power BI Desktop and Power BI Online. MariaDBdatasource

    7. Provide values for Username, Password and other settings, like Encrryption, as necessary and click Add. This will create and test your MariaDB data source in Power BI Online. ConnectionSuccessful

  6. In Power BI Desktop click Publish to publish your report with the MariaDB data source to Power BI Online.
  7. Test the report Power BI Online app.powerbi.com. It should successfully fetch the data from your MariaDB on-premise database via the Gateway using the MariaDB Power BI Connector.