Power BI
NewAdd "sharePointLinkedPbixUrl" and "sharePointLinkedPbixStatus" properties to "Get Import(s) [In Group]" REST API results
James Bartlett on 02 May 2023 17:28:52
Currently, when we call the Imports - Get Import(s) [In Group] REST APIs, we can see the "source" property that tells us which PBIX files were imported from SharePoint, and we can also see the "webUrl" property for each report/dataset. However, there's currently no "sharePointLinkedPbixUrl" property to indicate where we can find the original PBIX file in SharePoint for each report/dataset, and no "sharePointLinkedPbixStatus" property to indicate whether updates to that PBIX file in SharePoint will automatically sync to the corresponding report/dataset in Power BI as well.
Storing PBIX files in SharePoint is a great way for small and/or non-technical teams to achieve baseline version history on their Power BI reports/datasets, and with free tools like Power BI Version Control readily available, SharePoint-based version control for PBIX files has never been easier. Please add "sharePointLinkedPbixUrl" and "sharePointLinkedPbixStatus" properties to the results from the Get Import(s) [In Group] REST APIs, which will make it much easier to figure out which reports/datasets are linked to which PBIX files in SharePoint, and whether changes to a PBIX file in SharePoint will automatically sync to its corresponding report/dataset in Power BI.