Power BI FAQs

PowerBi Collector: v3.3.15

The below Power BI Datasource Connectors are currently supported for K Lineage. Refer back to this page for upcoming releases and new connection types.

Power BI Power Query Connections

Paginated Report Connections

K - Power BI Activity Event Mapping

To provide usage information around the PowerBI environment, Kada leverages PowerBI’s Activity Events. This endpoint tags and groups actions into PowerBI specific operation terminology - https://learn.microsoft.com/en-us/fabric/admin/operation-list.

KADA has mapped the following operations into K-specific usage activity (ie read, write downloads).

Known Limitations

Download Report Enabled

KADA relies on downloading report PBIX for Report Sheet level lineage.

Common Download Errors

• The Download time exceeded 120s warning occurs for large report sizes. The export_timeout field on collector setup limits the time allowed for download. Scale as necessary for your organisation’s requirements. The limit is provided to help with overall collector performance and will skip reports that take longer than the allocated timeout.

• The ServerError_PremiumFilesErrors_OperationIsNotSupportedForPremiumFilesModel error occurs when using the Power BI REST API to export reports based on large datasets (often >3GB) that use the "Premium Files" storage format, which is not currently supported for export operations.

• The PowerBIEntityNotFound error occurs commonly when the service account used does not have the necessary access requirements to the report. The service account must be added to required workspaces to enable report download.

Datasets Detailed Lineage

• Detailed Lineage (Datasets down to their table level information) requires a refresh of the datasets in the workspaces that we want K to profile once the Enhance admin API setting has been activated.