Data Mashup Explorer allows you to explore the Power Query mashups and supporting details contained in a Microsoft Excel or Microsoft Power BI file. Primarily, this tool is useful for learning about the little known but non-secret file format used by these Microsoft applications to save mashups.
Download & Prerequisites: (see tool’s page)
The user interface is simple. On the left, an Explorer-like tree lists the various components in the data mashup’s binary stream. Select one, and its contents are displayed on the right. For details on these various components, see (post coming soon about the underlying file format).
Special handling is given to Metadata, whose native format (a combination of XML, JSON and several binary formats) is complex and verbose. Metadata’s tab JSON presents a unified and simplified view with almost all binary formats translated and with repetition and extra syntax minimized.
If the tool misbehaves on you, please drop me an email. If you have an idea for a feature or improvement, you’re welcome to add your suggestion below as a comment or email.
Looking at Data Mashup Explorer’s output might make you wander if Power Query mashups can be edited using an external tool…or maybe you’d like a way to extract mashup information using a script so you can process it further…. Stay tuned (hint! hint!).
For notification of new versions, follow @bgribaudo on Twitter.