John Keller

Data Mart: Setting up Power BI

by

The PEARS data mart can be used in combination with Power BI as follows. Prerequisites Setup Power BI can connect directly to the data mart using the PostgreSQL provider, npgsql. This provider and its necessary drivers are installed with Power BI Desktop and Power BI Gateway. However, before a trusted connection can be established with … Read more

Data Dictionary

by

The Data Dictionary provides information about the tables in the data mart, including the columns, descriptions, and relationships. From the PEARS homepage, hover the cursor over the Support and Resources menu, displayed as a question mark icon, then click Data Dictionary. A set of tables is displayed. From this view at any time, you can … Read more