PBI-DataVizzle

REM Uses pbi-tools to extract the data model info and create the BIM file associated with each PBIX file in the directory
REM Batch file code written by Brian Julius, October 8, 2024

REM @echo off
SETLOCAL ENABLEDELAYEDEXPANSION
REM ============================================================
REM Batch Script to Extract BIM Files from PBIX Files
REM All PBIX files are in C:\test
REM All BIM files will be written to C:\test\bim_files
REM ============================================================

PBI-DataVizzle

let
  Switch = Function.From(
    type function (value as any, l as list, default as any) as any, 
    (params) =>
      let
        // Function to select nth item of list
        // If you pass in zero, you get even indices
        // If you pass in one, you get odd indices
        fnSelectEvenOdd = (lst as list, remainder as number) as list =>
            let 

PBI-DataVizzle

let
  pqmath.Benford =
    let
      Benford = Function.From(
        type function (num as number) as record,
        (params) =>
          let
            len = Text.Length(Text.From(params{0})),
            first = if len >= 1 then Number.From(Text.ToList(Text.From(params{0})){0}) else null,
            second = if len >= 2 then Number.From(Text.ToList(Text.From(params{0})){1}) else null,

PBI-DataVizzle

Sparkline Line = 

// Static line color - use %23 instead of # for Firefox compatibility
VAR LineColor = "%2301B8AA"

// "Date" field used in this example along the X axis
VAR XMinDate = MIN('Table'[Date])
VAR XMaxDate = MAX('Table'[Date])

// Obtain overall min and overall max measure values when evaluated for each date

PBI-DataVizzle

# Install the MicrosoftPowerBIMgmt module required for managing Power BI resources.
# This module is installed for the current user only, to avoid system-wide changes.
Install-Module -Name MicrosoftPowerBIMgmt -Scope CurrentUser

# Authenticate to the Power BI Service.
# This step is necessary to access and manage Power BI resources.
Login-PowerBIServiceAccount

# Function to retrieve all Power BI workspaces.
# It fetches data from the Power BI API and handles pagination to get all workspaces.

PBI-DataVizzle

#r "System.Net.Http"
using System.Net.Http;
using System.Text;
using Newtonsoft.Json.Linq;

// You need to signin to https://platform.openai.com/ and create an API key for your profile then paste that key 
// into the apiKey constant below
const string apiKey = "<YOUR API KEY HERE>";
const string uri = "https://api.openai.com/v1/completions";
const string question = "Explain the following calculation in a few sentences in simple business terms without using DAX function names:\n\n";

PBI-DataVizzle

// =====================================
// Author: Darren Gosbell
// Date: 12 Apr 2023
// This script works in Tabular Editor and sets the MaxParallelismPerQuery 
// setting at the database level.
// =====================================

if (Model.Database.CompatibilityLevel < 1569)
{
    Model.Database.CompatibilityLevel = 1569;

PBI-DataVizzle

// This gist containt useful pieces of DAX code

PBI-DataVizzle

//This gist contains useful tabular editor scripts. 

PBI-DataVizzle

// This gist containt useful pieces of M Query code