CODEWITHSUNDEEP
powerbipowerbi-desktop
Randy Minder
Randy Minder

Reputation: 48402

Is it possible to extract the JSON metadata from a PBIX file?

Recent versions of Power BI Desktop have included a preview feature to "Store datasets using enhanced metadata format" which stores the model metadata in a JSON format. However, since the PBIX file is in a proprietary Zip format, you just can't open it and peek inside.

Is it possible to somehow extract this JSON model metadata from a PBIX and save it as a JSON file?

Upvotes: 3

Views: 5795

Answers (2)

Alexis Olson
Alexis Olson

Reputation: 40204

You can change the extension on a PBIX file to .zip and peek inside like a normal zip folder.

It looks something like this:

PBIX Zip

Most of these files can then be opened with a text editor.

Upvotes: 4

msta42a
msta42a

Reputation: 3741

Do you Try to open Your PowerBI model in TabularEditor and save it to file?

https://github.com/otykier/TabularEditor/wiki/Power-BI-Desktop-Integration

enter image description here

Then we have everything in a json format

Upvotes: 2

Related Questions