Add more metadata from DAX Studio, PBI Helper Software, Zipped Power BI File

[some1ataplace]

Thank you for writing this program, it has helped me automate metadata collection for thousands of Power BI files.

I would love if you added more metadata similar to DAX Studio or Power BI Helper software produces. There is also all the metadata that lives in a zipped version of the Power BI file (open a power bi file with a zip program of your choice to see the contents - mostly JSON).

https://stackoverflow.com/questions/64607918/is-it-possible-to-extract-the-json-metadata-from-a-pbix-file

https://medium.com/@gelo.blancada/dissecting-a-power-bi-dashboard-1e5017e69974

dax_measures in its current implementation is missing stuff like:
IsHidden
FormatString
DataType
ErrorMessage
DisplayFolder
etc.

tables in its current implementation is missing stuff like:
IsHidden
etc.

Add a new model.columns (similar to what DAX Studio's SELECT * FROM $SYSTEM_TMSCHEMA_COLUMNS):
Table Name
Column Name
Data Type (inferred and explicit)
Description
DataCategory
IsHidden
IsUnique
IsKey
IsNullable
FormatString
SourceColumn
DisplayFolder
ErrorMessage
etc.

Add a new model.datasources (similar to what DAX Studio's SELECT * FROM $SYSTEM_TMSCHEMA_COLUMNS):
Add a new model.hierarchies (similar to what DAX Studio's SELECT * FROM $SYSTEM_TMSCHEMA_HIERARCHIES):
Add a new model.perspectives (similar to what DAX Studio's SELECT * FROM $SYSTEM_TMSCHEMA_PERSPECTIVES, SELECT * FROM $SYSTEM_TMSCHEMA_PERSPECTIVE_MEASURES, SELECT * FROM $SYSTEM_TMSCHEMA_PERSPECTIVE_COLUMNS, SELECT * FROM $SYSTEM_TMSCHEMA_PERSPECTIVE_TABLES, etc.):

Perspectives and all of their contents (measures, tables, sets, hierarchies, columns, etc.). Perspectives are very useful if you have a large data model and you want to analyze the data from the model into smaller easier to understand views. For example, if you are creating a new model, you may want to make it easier for users not to mess up by choosing the wrong measure and the wrong columns that do not have proper relationships. Sometimes there are missing things from the perspective that are in the main model or vice versa, and you want to spot check that everything is in the proper place.

ReportPages (tabs or sheet names in the Power BI file)
Visuals that exist on each tab or sheet name (pivotTable, slicer, textbox, actionButton, etc.)
Show what measures, columns, rows, filters are being used for each visual on each tab or sheet name
Show any global filters used on the entire tab or sheet name (not each visual)
Unused Fields (list of all fields that are not being used in all Power BI visuals)
Used Fields (list of all fields that are being used in all Power BI visuals)
Unused Tables (list of all tables that are not being used in all Power BI visuals)
Used Tables (list of all tables that are being used in all Power BI visuals)
Bookmarks
Roles
Queries, DataTransforms, Filters, Projections, ColumnProperties, ProtoTypeQuery, QueryFieldParametersByRole, ExpansionStates, Objects, etc.