Connect Microsoft Power BI Desktop

The following article is going to walk you through connecting your Fusion created data warehouse to Microsoft Power BI Desktop. 

Before connecting your fusion created data warehouse to Microsoft Power BI Desktop you will need to make sure that you have download the MySQL connector, which you can do here

Power BI Gateway Connections

Note that for each data provider, Power BI supports a specific provider version on objects. For more details on those requirements, see this document. For Power BI Gateway connections, you will want to download Connector/NET, a fully-managed ADO.NET driver for MySQL.

Enterprise gateway users will need to restart the Gateway service to make the new connector available. Next, you should configure the data source. The server url setting will be a combination of the host and port in your credentials file, and will look something like prod-freedom-mysql.2gafd3uofdsa.us-east-1.rds.amazonaws.com:3306. 

Adding a MySQL Data Source in Power BI

When opening Microsoft Power BI you are going to see the following window. On this page you are going to click "Get Data".

After clicking "Get Data" you are going to see a couple different options. On this page you are going to select "MySQL database" and then click "Connect".

You will then be prompted to enter your warehouse credentials. This information can be found in the Fusion Portal. You can learn more about how to get these credentials here. (Note: If you haven't installed it already, download and install the MySQL driver as prompted.) As depicted below, you'll want to enter your server URL, which must include the host and port information provided by Bedrock Data.

For example, if the host and port provided are prod-freedom-mysql.csxkpi7oalo6.us-east-1.rds.amazonaws.com and 3306, the server URL would be prod-freedom-mysql.csxkpi7oalo6.us-east-1.rds.amazonaws.com:3306

After clicking 'OK", select Database on the left sidebar, and then enter your username and password.

You should now be all set and connected to your Fusion Warehouse. 

Still need help? Contact Us Contact Us