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
- Click on the Integrations link in the sidebar of superQuery:
- Enable your desired connection by clicking “Connect”
- After clicking “Connect” you’ll see the username and password screen, like so:
- Whitelist your IP Address if necessary
- 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.
- 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
- Open Power BI and click “Get Data”. You will get the following screen:
- 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
- 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.
- 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
- Click on “Edit query”.
- Write your query in the ‘Query’ section.
- 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: