read DataModelSchema.json into Python

[jch]

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)

[Anonymous]

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

[Anonymous]

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

[Dave53]

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