Insights Data Access and Power BI

Hi,
we have used the Collibra available API’s to get information from Collibra to PowerBI but it is tricky. If the extracted data set is big, it can crash the Collibra instance. I would seek Collibra Coatching etc. for help before doing this in prod. We had lots of issues before we got the data extractions working. They are now split into multiple small ones that are combines in PB and we also needed to adjust the parameters of extract according to Collibra provided instructions.

Do you have any news or documentation related to it? Any additional detail? Thanks

Put the Insights ERD into your DB, eg Redshift. Then point Power BI at the DB. The same as you would do for Tableau. The pattern is whatever you want but could be;

• staging schema - load daily insights snapshots (parquet)
• core schema - load from staging, applying SCD2 then truncate staging
• reporting schema - load from core with (business) transformation as appropriate to build your star/snowflake schema with business context
• point Power BI at the reporting schema and build your reports ;-)