Skip to main content
Skip table of contents

Manual Reports Creation

To manually create the reports, open Power BI and:

  1. Establish the connection to your database:

    1. Click Get data, More.... In the new window, select Other, click on ODBC on the list, and click Connect. In the new prompt, select the Data source name (DSN) you created in the ODBC Data Sources app and click OK.

      Select DSN
  2. In the Navigator window, select all the options with the DIM_ and FACT_ prefixes and click Load (see Database Views description).

    Navigator options
  3. Power BI loads the data, however the relationships between them must be created manually, since Power BI cannot extract them:

    1. Go to the Modeling menu and click on Manage relationships.

    2. Click New... and create the relationships between the views, selecting the IDs in each of them. Click OK once done.

      Create Relationships
  4. Your model has been created and you can add visualizations to the report.

Power BI model view

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.