TinyToons

<# 
.SYNOPSIS
Export Power BI Model Size

.DESCRIPTION

#>

function Export-ModelSize{
    param(

TinyToons

#PLEASE OPEN YOUR POWER BI DESKTOP FILE BEFORE RUNNING THIS SCRIPT!!!!!

#Gets a list of teh ProcessIDs for all Open Power BI Desktop files
$processids = Get-Process msmdsrv | Select-Object -ExpandProperty id 
   
#Loops through each ProcessIDs, gets the diagnostic port for each file, and finally generates the connection that can be use when connecting to the Vertipaq model.
if($processids)
{
    foreach($processid in $processids)
    {

TinyToons

let
    fnFormatted = let
    func = (myTable as table) =>
        let
            #"Table1 Schema" = Table.Schema(myTable),
            TypesList = Table.AddColumn(
                #"Table1 Schema",
                "TypeRecord",
                each "#""" & [Name] & """=" & [TypeName]
            )[TypeRecord],