D

4 Messages

 • 

400 Points

Thursday, January 19th, 2023 4:48 AM

Insights Data Access and Power BI

Hi,

We are looking to build a reporting dashboard with Power BI utilizing Insights Data Access.

Collibra’s Product Resources has instructions on how to do this through Tableau, however, our client is a Power BI organization.

Would anyone have examples of getting these steps to work with Power BI instead of Tableau?

Thanks,

Darren

1 Message

2 years ago

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.

6 Messages

11 months ago

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

143 Messages

 • 

9.8K Points

7 months ago

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 ;-)   

9 Messages

 • 

200 Points

@grantrollerson1​ is there please any documentation How to download Insight Data? I found only general info:

Entity relationship diagram (collibra.com)

and marketplace creat script:

Insights Data Access - Collibra Marketplace

But no manual how to access and download snapshots, or from where.. Is there API for it?

Thank you

Ivan

Loading...