PowerShell to retrieve Power BI Data

[amsrivas]

Hi All,

Is there any way to retrieve below information for Power BI using PowerShell

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.

Note : I am not looking for PowerBIActivityData

Thanks

Amit Srivastava

[V-lianl-msft]

Hi @amsrivas ,

Try using Rest API in PowerShell.

https://docs.microsoft.com/en-us/rest/api/power-bi/reports/getreports 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amsrivas]

Hi @V-lianl-msft 

I have already tried provided API however it will give relationship between WorkSpace, Report and Dataset.

However, i am looking to established relationship between

1. DataFlow and Report

2. Report and Users (who has access to report)

Thanks

Amit 

[amitchandak]

@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]

Hi @amitchandak 

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.

Please suggest!!

Also, if there any other way to retrieve this data via some other mehtod will be good.

Thanks

Amit