Skip to content

Instantly share code, notes, and snippets.

@dankkom
dankkom / powerbi_extractor.py
Created March 9, 2023 18:46 — forked from svavassori/powerbi_extractor.py
PowerBi Extractor in Python
import sys
import csv
import json
# Converts the JSON output of a PowerBI query to a CSV file
def extract(input_file, output_file):
input_json = read_json(input_file)
data = input_json["results"][0]["result"]["data"]
dm0 = data["dsr"]["DS"][0]["PH"][0]["DM0"]