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

Viewed 1817

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?

2 Answers

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.

Related