PowerShell to retrieve Power BI Data

Question

Hi All,Is there any way to retrieve below information for Power BI using PowerShell&nbsp;1. Powershell script to retrieve data which has Relationship between Dataflow and Report.2. Powershell script to retrieve data which has Relationship between Report and user.&nbsp;Note : I am not looking for PowerBIActivityData&nbsp;ThanksAmit Srivastava

amitchandak · Answer

amsrivas , I think you are looking for Cmdlets, But doubt I have seen them, in the first look at this document 
https://docs.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps

amsrivas · Answer

Hi&nbsp;amitchandak&nbsp;Yes, I am looking for Power BI CMDLETS only, however I have already tried all the commands listed in the provided link however couldn't able to fetch required information.&nbsp;Please suggest!!&nbsp;Also, if there any other way to retrieve this data via some other mehtod will be good.&nbsp;ThanksAmit

v-lianl-msft · Answer

Hi amsrivas&nbsp;,&nbsp;Try using Rest API in PowerShell.https://docs.microsoft.com/en-us/rest/api/power-bi/reports/getreports&nbsp;&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amsrivas · Answer

Hi&nbsp;V-lianl-msft&nbsp;I have already tried provided API however it will give relationship between WorkSpace, Report and Dataset.&nbsp;However, i am looking to established relationship between1. DataFlow and Report2. Report and Users (who has access to report)&nbsp;ThanksAmit&nbsp;

Forum Discussion

PowerShell to retrieve Power BI Data

4 Replies

Related content

Retrieving data via HTML

Cannot retrieve Contacts from API

Retrieving deleted notebook

PowerShell script to retrieve list data sources used in Power BI dataset

Power BI Get Data using Powershell