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

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "usermeta": {
    "deneb": {
      "build": "1.4.0.0",
      "metaVersion": 1,
      "provider": "vegaLite",
      "providerVersion": "5.4.0"
    },
    "interactivity": {

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>";
const string uri = "https://api.openai.com/v1/completions";
const string question = "Please describe this power query code for me:\n\n";

PBI-DataVizzle

#r "System.IO"
#r "Microsoft.Office.Interop.Excel"

using System.IO;
using Excel = Microsoft.Office.Interop.Excel;

string filePath = @"C:\Desktop\Descriptions"; // Update this to be the desired location of the Descriptions file
string excelFilePath = filePath + ".xlsx"; 
string textFilePath = filePath + ".txt";
string excelTabName = "ModelDescriptions";

PBI-DataVizzle

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "name": "trellis_barley",
  "description": "Trellis",
  "title": {
    "text": "Ingressi giornalieri in Terapia Intensiva (TI) a confronto con ricoveri totali in TI",
    "color": "#168CC7",
    "fontSize": 18,
    "anchor": "start",
    "font": "Montserrat",

PBI-DataVizzle

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "description": "A faceted chart showing movie ratings across different franchises.",
  "transform": [{"calculate": "1", "as": "max"}],
  "data": {
    "values": [
      {"name": "Star Wars", "Film": 1, "Rating": 0.9},
      {"name": "Star Wars", "Film": 2, "Rating": 1},
      {"name": "Star Wars", "Film": 3, "Rating": 0.8},
      {"name": "Indiana Jones", "Film": 1, "Rating": 1},

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

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "description": "A line chart with highlighted area above the maximum value.",
  "data": {
    "values": [
      {"x": 2015, "y": 33},
      {"x": 2016, "y": 45},
      {"x": 2017, "y": 35},
      {"x": 2018, "y": 34.5},
      {"x": 2019, "y": 34},

PBI-DataVizzle

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "description": "A line chart with highlighted area above the maximum value.",
  "data": {
    "values": [
      {"x": 2015, "y": 33},
      {"x": 2016, "y": 45},
      {"x": 2017, "y": 35},
      {"x": 2018, "y": 34.5},
      {"x": 2019, "y": 34},

PBI-DataVizzle

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "description": "A cumulative line chart with highlighted area above the maximum cumulative value on a monthly axis.",
  "data": {
    "values": [
      {"Date": "2023-01-01", "value": 10},
      {"Date": "2023-02-01", "value": 20},
      {"Date": "2023-03-01", "value": 30},
      {"Date": "2023-04-01", "value": 25},
      {"Date": "2023-05-01", "value": 40},