Dual Code's Microsoft Power BI Tableau Desktop integration lets you connect Dual Code's data to Power BITableau Desktop. Once connected, Power BI Tableau Desktop lets you visually display your data with charts and graphs, and create reports.
| Info |
|---|
The Microsoft Power BI Tableau Desktop Integration services described below may require additional one-time and/or annual fees. For more information, please contact us. |
Step-by-step Guide
To push pull Dual Code learning records and data to Power BI Tableau Desktop:
- Open Power BI Tableau Desktop.
- From the Home tab, click Get Data and select More.
- Search for MySQL Database and click Connect.
- Paste the username and password provided to you by Dual Code and click OK.
- Click Connect.
- Select the tables you want to push data to Power BI and click Load.
...
- screen in the left-hand sidebar 'Connect', chose 'MySQL' (Please ensure any MySQL ODBC drivers are installed for Tableau Desktop)
- In the dialog enter your Dual Code BI credentials and click 'Sign in'
- Now you can work with the data as needed
Note: These steps are based on Tableau Desktop v2020.4.2
Check out the Tableau Help for more info on how to use Power BITableau Desktop.
Technical Notes
The following technical details are worth noting:
...
- The ID column in a table always represents the primary key and usually has the comment of "Primary key of the table."
- A foreign key usually has the comment of "Key referencing the primary key in the [tablename] table."
...
Important Notes
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|