Allow API Endpoint For Retrieving PBIT (Power BI Template File) From Existing Dashboards
Related: https://community.fabric.microsoft.com/t5/Developer/What-API-can-a-client-app-use-for-downloading-reports-from-Power/td-p/3459280
I would like to request that an API endpoint be exposed for the purpose of programmatically collecting PBIT files from dashboards published to the Power BI web environment. This would serve the community by enabling automated metadata harvesting as it relates to data lineage.
Power BI already exposes metadata for Pro subscribers via API, which allows for integration into many metadata management systems. This is a very helpful feature, but it's also incomplete as it exists now. There is no conventional manner of harvesting metadata that can be utilized for data lineage tracking.
Take for example, OpenMetadata. Their documentation (https://docs.open-metadata.org/latest/connectors/dashboard/powerbi/powerbi-pbit-lineage) advises to follow the Microsoft docs for retrieving a PBIT file--essentially manually exporting the file via Power BI Desktop--and uploading the file somewhere that it can be consumed by OpenMetadata (e.g., an Azure datalake bucket, S3 bucket, ...).
As it stands, this process could be improved by providing the ability to retrieve PBIT files for existing dashboards via API. With this functionality, it would become possible to harvest PBIT files for Power BI dashboards via automated processes. The integration of the PBIT data could then also be automated, allowing for stronger and more robust integration with with metadata management solutions.
This improvement would pave the way for including Power BI dashboards in many services that are powered by metadata management systems, allowing Power BI to be evermore integrated with the diverse and dynamic data stacks used by modern businesses.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Paste values in slicers for hierarchy data
Hierarchical slicers are widely used in enterprise reports (for example Product RCN > SKU Key, Region > Country > City, or GPP > Division > RCN > SKU). Users often need to bulk-filter by pasting valu...eddieisking20001 minute agoFrequent VisitorNew0Views0likes0CommentsPower Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes2 hours agoNew MemberNeed Clarification202Views3likes2CommentsMake Copilot Approval status for semantic model available through API
In recent versions fabric allowed to mark a semantic model as approved for copilot to reduce AI adoption friction. However there is no specific way for external governance application to analyse whi...FrançoisD2 hours agoFrequent VisitorNew7Views0likes0CommentsClone a workspace, including its data, to a new workspace
Description: Today there's no way to fully clone a Fabric workspace: git sync and Deployment Pipelines move item definitions only, not the underlying data; Warehouse's zero-copy CREATE TABLE ... AS ...gclements3 hours agoHelper IINew12Views1like0CommentsAllow NotebookUtils getSecret() to authenticate with Workspace Identity
Current behavior In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook. This behavior appli...tmihara9 hours agoNew MemberNew8Views0likes0Comments