Skip to main content

Power BI

Completed

Retrieve Power BI App information using PowerShell

Vote (20) Share
's profile image

on 28 Mar 2018 17:37:46

Currently I am working on some PS scripts to be able to manage the enterprise implementation of Power BI. One of the things I am not able to find is retrieving App-information using PowerShell. For example: I would like to create a list of Apps (based on workspaces) that has been distributed within the tenant and the users who can access the Apps. Other information, like last updates, included datasets and reports, etc, would be grate as well.

Administrator on 10 Jun 2021 18:36:23

REST APIs now exist to query apps and app access information.

Comments (3)
's profile image Profile Picture

M Haldeman on 05 Jul 2020 23:53:47

RE: Retrieve Power BI App information using PowerShell

Yes, a big missing feature from a data security standpoint. I am tasked with Power BI Governance and Access Security reporting. I have reports for Workspace membership, but not who can see data in the published Apps.

This post is a year old. Power BI Team, is this ever going to happen?

's profile image Profile Picture

jerome P on 05 Jul 2020 23:17:47

RE: Retrieve Power BI App information using PowerShell

I agree
we need more features.
I want to document what has been published
and I would like to document the content of the reports too, down to the measures used in each report.

So I'll be able to know where a measure is used and be able to do impact analysis faster (if I change 1 measure in an SSAS tabular server based model, I'll be able to know which report will be impacted)

's profile image Profile Picture

Antoine Richet on 05 Jul 2020 23:17:17

RE: Retrieve Power BI App information using PowerShell

A big missing feature is a way to retreive (PowerShell, C#,..) the security access affected to an Apps.