Share on facebook
Share on linkedin
Share on twitter
Share on reddit

Connecting Microsoft PowerBI to superQuery

These instructions explain how to connect your PowerBI account to superQuery’s query optimization engine.
 
When connected, your queries will pass through superQuery — where it will be automatically optimized — before being executed in BigQuery. 
 

The result: a significant reduction in query costs and execution time.

General 

  1. Click on the Integrations link in the sidebar of superQuery:

  2. Enable your desired connection by clicking “Connect”
  3. After clicking “Connect” you’ll see the username and password screen, like so:

powerBI

 

  1.  Whitelist your IP Address if necessary
  2.  Copy the hostname and port from this window into your service of choice.
    • server: bi.superquery.io
    • port: 3306

6.  Finalize the connection.

Prerequisite

Client

  • Download the PowerBI desktop application
  • Download the MySql connector  .NET
    (
    https://www.mysql.com/products/connector/)
    • The correct driver to download depends on your OS. If you’re using Mac, for instance, then JDBC will be appropriate.

Connect Power BI to SuperQuery

  1. Open Power BI and click “Get Data”. You will get the following screen:

  2. Select “MySQL database”.
    • Server:  Insert server IP with port or hostname with a port, for example bi.superquery.io:3306
    • Database: Insert valid values in this format: <project>.<dataset>, for example: mydata.mydataset

  3. Insert your MySQL credentials
    • The superQuery team will provide you with a username and password which you can find in the integrations section of the superQuery web interface.


Query the data

  1. Click on “Edit query”.
  2. Write your query in the ‘Query’ section.
  3. Click √ to check your query. If it passes, click refresh to see the result.

Example:

= MySQL.Database(“lior.test.com:3306”, “project.database”, [ReturnSingleDatabase=true, CommandTimeout=#duration(0, 0, 10, 0), Query=”select 5″])

Now you can start building your own beautiful dashboards. 

Query on! 🙂

Example:

Ready to run perfect queries?

Free to get started. No credit card required.

  • © 2019 superQuery. All rights reserved.