Want to fetch all the dashboard name and user list who have the access of dashboard in a workspace

[Anonymous]

I need to fetch the all the dashboard name published in perticular workspace and user list who have the access of dashboard. 

I want to fetch this data into power bi desktop and need to refresh every day because might be today we have given the access of the dashboard to 10 people but tommorow user list can be increase or decrease

[Anonymous]

Hi @freginier Thank you for reply. I am very new to api and don't sure how it will help me to get data into power bi dasktop.

[MikeJohnsonZA · Accepted solution]

Hi

There are two approaches, one is to call the REST API directly from Power Query (see Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Docs), this can get complex because you will need to manage both the tokens and may need to loop through some of the result sets.

The second and easier (and better in my opinion) approach is to use the PowerShell Power BI cmdlets (see Power BI Cmdlets reference | Microsoft Docs) which create an easy to use wrapper around the API's, each API will return JSON objects that you can store either locally or in the cloud then build your reports off that. a great starting point is this project on Github (RuiRomano/pbimonitor (github.com)) that provides you with all the code as well as how to set it up to run locally or in the cloud using azure functions.

[freginier]

You need to use Power BI API 

https://docs.microsoft.com/en-us/rest/api/power-bi/reports/get-reports-in-group