![]() Are they building on top of the company data warehouse (e.g. One of the first steps you might take is determining what data sources they’re using. You might image a scenario in which a team that owns a workspace has asked for additional resources from the IT/BI team to support their solution. Even if these limitations didn’t exist, it might still be helpful to have a simple script that can loop over the datasets in a workspace and retrieve the data sources associated with each. However, currently there’s no option to export this metadata and data sources are not supported in the GetGroupsAsAdmin API. The lineage view in Power BI exposes the data sources of datasets in a workspace in a clean, visual UI. Get Data Sources from Datasets in a Workspace Several of the primary properties are retrieved including UserPrincipalName, DisplayName, and Mail and the members and owners are exported out to separate CSV files. This script uses the AzureAD module from the context of PowerShell 7.1.3 to retrieve the owners and members. Combined with knowledge of what permissions the group is mapped to, this data answers the question “Who has this access/permission?”. ![]() Since groups are used throughout Power BI (and elsewhere) for provisioning access to various resources and features it’s important to be able to quickly and easily find out who is in a group (members, service principals?) and who owns the group (if anyone). Get Group Owners and MembersĪs a Power BI administrator, knowing who has access to what and optionally adjusting this access is a fundamental responsibility. Power BI Admin role) and software installed such as the latest Power BI Management PowerShell modules. Please be sure to read through the prerequisites section of Part I and confirm you have the necessary permissions (e.g. Like Part I, the five new scripts have been added to my GitHub repository and I’ll only share context in the blog. Today’s post builds on top of Power BI Admin Scripts Part I by describing five additional PowerShell scripts that Power BI service administrators can utilize to address relatively common scenarios.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |