Power BI / Microsoft Fabric

Select Integrations and click on Enable on PowerBI / Fabric in the RevOS as a source list:

There you will get a necessary credentials information that you’ll need for the next step.

In PowerBI click on Get Data

and select Database → Big Query

Then click > Advanced options

and disable use of Use Storage Api by entering false in the field below, then click OK

On the next screen please select Service Account Login and use provided Service account email and Service account JSON file content content from the RevOS

Now you can browse and select tables that are required for your report

After you uploaded your report from PowerBI Desktop to your PowerBI Service Workspace select settings of the Semantic Model associated with the report:

Expand the Data source credentials and click on Edit credentials

In Authentication method select Basic

And use Service Account e-mail as a Username (1) and Service account JSON key as Password (2)

Now you can trigger a manual refresh or schedule an automatic refresh of semantic model for your report to always have a fresh data to support your data-driven decisions.

If you see following error:

reason for that is that PowerBI connector configured to use optional Storage API, however it can be disabled by setting an advanced connector configuration Use Storage Api to false or modify the M code that fetches tables from = GoogleBigQuery.Database() to = GoogleBigQuery.Database([UseStorageApi=true])

Yes, connector works for both Desktop version of PowerBI as well as PowerBI / Fabric service where you would be able to do automatic data refreshes and use all benefits of scalable BI service offering of Microsoft. See here for more information.

Yes, the connectivity you use to fetch data uses a connector build and certified by Microsoft that uses encrypted channels using state of the art and constantly updated encryption mechanisms.

Your data in RevOS is updated at least every 24 hours (or more frequent, according to your configuration and pricing plan). If you use ‘Direct Query’ to load data into the PowerBI report your report will always show the latest state of RevOS data, if you use ‘Import’ for pulling data in to the report you can configure refresh frequency on the PowerBI service.

See full list of entities in the documentation about the individual connectors, e.g.

Depends on the data, if you import results of your scoring models they can be edited in RevOS. Data that is synced from other systems is exposed as-is to PowerBI. You can however use PowerQuery or DAX to modify the data during and/or after import to PowerBI.

Connection errors can arise due to several issues, such as incorrect API key permissions or firewall settings blocking data transfer. Ensure that your Service Account E-Mail and JSON Keys are correctly configured and you can access RevOS platform. If issues persist, reach out to support at revos.ai and we will help you.