topic Re: read DataModelSchema.json into Python in Developer

read DataModelSchema.json into Python

jch — Mon, 27 Sep 2021 19:26:06 GMT

I downloaded a .pbix file and remamed it to .pbit so I could extract DataModelSchema.json.

Has anyone else had luck reading this .json into a python pandas dataframe? In this example, I changed the file name from DataModelSchema.json to datamodelschemasampledl.json

Is there a certain encoding I should use with the .json from Power Bi? Thanks in advance for any suggestions

This code:

import json with open("C:\datamodelschemasampledl.json", "r") as f: schema_data = json.load(f)

gives me the error:

JSONDecodeError: Expecting property name enclosed in double quotes: line 1 column 2 (char 1)

Re: read DataModelSchema.json into Python

Anonymous — Thu, 30 Sep 2021 01:41:11 GMT

HI @jch,

The 'DataModelSchema' file should be stored in the pbix file but you cannot directly extract it from pbix file. For this scenario, you can try to import some libraries about compression to analyze the file (pbix file can be recognized with compression software), then you can looping from the recognize folder/path to find out the corresponding contents. (notice: these operations may not directly execute in power bi desktop when you open the report, they may face the read/write protected/permission issues)

Regards,

Xiaoxin Sheng

Re: read DataModelSchema.json into Python

Anonymous — Mon, 11 Jul 2022 18:40:16 GMT

I'm having this same issue. Did you ever figure this out?

Re: read DataModelSchema.json into Python

Anonymous — Fri, 17 May 2024 23:26:59 GMT

I know this topic is very old and outdated, but I just put the answer out there : this file is encoded in utf-16le