Informatica CDGC doesn’t provide an out-of-the-box catalog source for scanning metadata from on-premise Power BI, so creating a custom catalog source is essential. Managing custom metadata for on-premise Power BI reports can seem complex, but this guide simplifies it! You’ll learn how to leverage Informatica CDGC to ingest and manage Power BI metadata efficiently. By walking through the process of creating a custom model and catalog source, we’ll help you seamlessly ingest on-prem Power BI metadata, streamlining governance and improving data management.
Why Custom Catalog Source for Microsoft PowerBI?
Informatica CDGC offers an out-of-the-box catalog source for scanning metadata from PowerBI Cloud, but none for PowerBI On-premise. To ingest on-premise PowerBI metadata into CDGC, you’ll need to create a custom model and use that model to build a custom catalog source.
Why doesn’t Informatica CDGC offer an out-of-the-box catalog source for on-premise PowerBI?
The on-premise version of PowerBI, known as PowerBI Server, lacks APIs for metadata extraction, unlike the cloud version. As a result, Informatica has no direct way to extract metadata from PowerBI Server.
Get Started Now
Since on-premise PowerBI doesn’t provide any API to fetch metadata, you’ll need to extract it from PowerBI reports PBIX files. Here are the high-level steps:
- Create a custom model for PowerBI on-premise.
- Upload the model file to Informatica MCC.
- Download the metadata template files from MCC for this model, and populate them using data from PBIX files.
- Create a custom catalog source in Informatica MCC using the metadata files prepared in step 3.
- Run the catalog source and check the lineage in Informatica CDGC.
To simplify this process, we’ve included:
- A sample custom model file.
- A Python script that reads PowerBI reports PBIX files, generates metadata CSVs, and zips them. You can use this ZIP file for creating the custom catalog source.
Below is an example to help you get started with creating a custom model and extracting metadata from a PowerBI PBIX file for creating a custom catalog source for PowerBI On-Prem with connection assignment.
