Dual Code's Microsoft Power BI integration lets you connect Dual Code's data to Power BI. Once connected, Power BI lets you visually display your data with charts and graphs, and create reports.
| Info |
|---|
The Microsoft Power BI 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 Dual Code learning records and data to Power BI Desktop:
...
- The learning environment is based on Moodle, the world's most popular open-source learning management system. Moodle does not currently generate actual foreign key constraints in the database. As such, Dual Code has defined the relationship using the following convention.
- 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."
- When dealing with dates or times:
- As a general rule, most dates/times are stored in the database as a BigInt in epoch formatUnix time format (also known as Epoch time, POSIX time, seconds since the Epoch, or UNIX Epoch time). Some exceptions apply.
- The database read-only replica is in the same timezone as the production server.
...