Getting Started with Power BI and QQube | CLEARIFY

Getting Started with QQube™ and Power BI

Each QQube Data Model is already configured for Power BI including over 5,600 DAX formulas in the collection. The underlying tables are already linked, and the relationships are already established.  (In a typical data warehouse, there is only one way to attach the underlying tables).

We strongly suggest that you are always on the most recent version of Power BI.

All you need to do is open one of the examples, and refresh the data.

Open up the Configuration tool, and highlight Microsoft Power BI under the Examples section. You should see a list of Power BI examples - at least one for each data model.

If you see a data model example grayed out, please review this guide on selection and synching.

Step One

Check the synch logs to ensure successful and accurate data extraction.

Step Two

Open up the example from the QQube Configuration Tool.  It will open to a page with general instructions for:

• Refreshing your data
• How to handle the first time only password prompts

Step Three

Refresh your data

If you encounter any issues or error messages, you should again check to see that there are no synch errors, or that the correct data model was loaded as stated in the beginning of this guide.

Step Four

When you open the first example it may ask you for credentials, because Power BI won't use the built in passwords for the two DSN's we install.  If it does:

• DSN Name: QQubeFinancials with password Financials
• DSN Name: QQubeUser with password User

QQubeFinancials is the "super user" and is used in financial summary and payroll analytics.

Once you have entered the credentials for both, it won't be necessary again.

Credentials

If you encounter any issues or error messages, you should again check to see that there are no synch errors, or that the correct subject was loaded as stated in the beginning of this guide.