PowerPlatformGovernance

IT Governance helps to to monitor and control key information technology and processes in an organization. This repository contains presentations and helpful information to control your power platform components in your Microsoft 365 tenant. This repository is a joint project from Peter Hödl, Martina Grom, Toni Pohl, and Christoph Wilfing from atwork.at and will be extended from time to time with additional information and tools for automating governance tasks in Microsoft 365.

Administration of the Power Platform

• Microsoft Power Platform Admin Center: aka.ms/ppac
• Activate the Unified Audit Log in your tenant: aka.ms/Security-and-Compliance. See more at https://docs.microsoft.com/en-us/microsoft-365/compliance/search-the-audit-log-in-security-and-compliance. Note: It can take up to 30 minutes or up to 24 hours after an event occurs for the corresponding audit log record to be returned in the results of an audit log search.

Backup and Restore Flows

Update August 2022: Find a Backup1Flow and Restore1Flow in the Flows directory. These flows allow to create a backup of a flow to a SharePoint document library and to restore the saved flow in the same environment if needed with the restore flow.

For more information, see the article at blog.atwork.at.

Use PowerShell for Power Apps and Power Automate

Note: Earlier, the Power Platform modules required Windows PowerShell version 5.x. This is no longer required, now PowerShell Core is supported as well. To check the version of the PowerShell version running on your machine, run the following command:

$PSVersionTable.PSVersion

See more at https://docs.microsoft.com/en-us/powershell/powerapps/get-started-powerapps-checker?view=pa-ps-latest

# Install the modules from the PowerShell Gallery
Install-Module -Name Microsoft.PowerApps.Administration.PowerShell -Scope CurrentUser
Install-Module -Name Microsoft.PowerApps.PowerShell -AllowClobber -Scope CurrentUser
# Install-Module -Name Microsoft.PowerApps.Checker.PowerShell
# Check the latest version
Get-InstalledModule -Name Microsoft.PowerApps.Administration.PowerShell, Microsoft.PowerApps.PowerShell

Note: To automate, such PowerShell scripts can be executed in Microsoft Azure in an Azure Automation Account environment.

Use PowerShell for Power BI

The Power BI modules run in Windows PowerShell and in PowerShell core (v7.x). You can install them from the PowerShell Gallery.

# Install the modules from the PowerShell Gallery
Install-Module -Name MicrosoftPowerBIMgmt -Scope CurrentUser
# Check the latest version
Get-InstalledModule -Name MicrosoftPowerBIMgmt

Note: To automate, such PowerShell scripts can be executed in Microsoft Azure in an Azure Automation Account , or in an Azure Function v3 environment.

Access with SPN: Power BI also supports authentication with a Service principal to let a Microsoft Entra application access Microsoft Fabric content and APIs. The app must not have any admin-consent required permissions for Power BI set on it in the Azure portal. Service principals can access the /admin APIs in a read-only mode if enabled, such as https://api.powerbi.com/v1.0/myorg/admin/[method]. Follow the steps described at Enable service principal authentication for read-only admin APIs and the available endpoints at Power BI REST APIs - Admin. Find out more in the Power BI developer documentation.

Center of Excellence (CoE)

The CoE allows to monitor and react on activities in the Microsoft Power Platform: "The Microsoft Power Platform CoE Starter Kit is a collection of components and tools that are designed to help you get started with developing a strategy for adopting and supporting Microsoft Power Platform, with a focus on Power Apps and Power Automate." It´s a helpful tool for your governance projects.

A part of the CoE solution includes Power BI dashbards, as here.

There is a lot of information about the components included, such as a list of all apps.

...and much more. Give it a try.

• Install the CoE starter kit: aka.ms/coestarterkit
• Download the CoE starter kit: aka.ms/coestarterkitdownload

Develop a Power App

• See the helpful formula help: Formula reference for Power Apps

Develop a custom connector

• See Get started with Swashbuckle and ASP.NET Core
• Create and deploy an ASP.NET web app to Azure
• See this blog post series from Patrick Lamber at Describe-Your-Custom-Connector-With-An-Swagger

Power Virtual Agents

• Create your own chatbot with no code and start at powerva.microsoft.com

More

• Develop your own governance processes with automation, using PowerShell or APIs
• Check out our GovernanceToolkit365.com
• Check out other tools such as the Power Studio for the Power Platform from our MVP colleague John Liu

to be continued...