PowerShell Notebook to get you started with current PowerShell + Power BI capabilities.

GetStartedWithPowerBIcmdlets.ipynb

{
    "metadata": {
        "kernelspec": {
            "name": "powershell",
            "display_name": "PowerShell"
        },
        "language_info": {
            "name": "powershell",
            "codemirror_mode": "shell",
            "mimetype": "text/x-sh",
            "file_extension": ".ps1"
        }
    },
    "nbformat_minor": 2,
    "nbformat": 4,
    "cells": [
        {
            "cell_type": "markdown",
            "source": [
                "<img src=\"https://app.powerbi.com/13.0.10537.111/images/PowerBI96x96.png?raw=true\" width=\"10%\"> ➕\r\n",
                "<img src=\"https://github.com/Microsoft/azuredatastudio/blob/master/samples/notebookSamples/Graphics/AzureDataStudioLogo.png?raw=true\" width=\"10%\"> = ❤\r\n",
                "\r\n",
                "# Download Azure Data Studio from [aka.ms/GetAzureDataStudio](http://aka.ms/GetAzureDataStudio)\r\n",
                "\r\n",
                "# Download PowerShell Core from [aka.ms./PSCore6](http://aka.ms./PSCore6)\r\n",
                "\r\n",
                "# Download the Power BI cmdlets from the [PowerShell Gallery](http://PowerShellGallery.com)\r\n",
                "\r\n",
                ""
            ],
            "metadata": {
                "azdata_cell_guid": "23dabd3a-3392-4967-96ae-2219d65c02f5"
            }
        },
        {
            "cell_type": "markdown",
            "source": [
                "Install the Power BI PowerShell module from the PowerShell Gallery using the code below:"
            ],
            "metadata": {
                "azdata_cell_guid": "552cbcd6-3d3b-4575-a958-9e759d5d1170"
            }
        },
        {
            "cell_type": "code",
            "source": [
                "Install-Module MicrosoftPowerBIMgmt"
            ],
            "metadata": {
                "azdata_cell_guid": "15241daa-1948-4e05-a606-b4f727c7ec9c"
            },
            "outputs": [],
            "execution_count": 0
        },
        {
            "cell_type": "markdown",
            "source": [
                "Here are a few common Power BI tasks you can use these PowerShell Notebooks to accomplish.\r\n",
                "+ ✅ O365 Audit Logs (via PowerShell) [link](https://gist.github.com/SQLvariant/27e919da7f1843ae8aa87e5a314660f9)\r\n",
                "+ ✅ Power BI Report usage metrics (using O365 audit logs to accomplish this, above ⬆ )\r\n",
                "+ ✅ Power BI Workspace details & access info (via PowerShell) [link](https://gist.github.com/SQLvariant/be7e6a6b8aa959a85868c0ecce7f4e97)\r\n",
                "+ ✅ Export Power BI Reports from a Power BI Workspace [link]()\r\n",
                "+ ✅ Power Platform Gateways (via PowerShell) [link](https://gist.github.com/SQLvariant/32432b6dc6e72ecc88ac58360733733f)\r\n",
                "+ ❌ Power BI Premium Capacity metrics"
            ],
            "metadata": {
                "azdata_cell_guid": "0ae5fdd7-088d-4fb6-8fc6-b2ef9184544e"
            }
        }
    ]
}