Manual Reports Creation

To manually create the reports, open Power BI and:

1. Establish the connection to your database:

   1. For direct connection (only for MS SQL servers), click Get data, SQL Server and add the server and database name.

   2. For ODBC, 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.

      

      

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

   

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.

      

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