Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

POWER BI FILE EXTRACT

HOW TO EXTRACT METADATA FROM PBIX FILE 

1 Reply

  • Since you didn't provide clearly your request, I am assuming that you are looking for a tool to extract the metadata contained in the PBIX file.

    You can use the Power BI command-line interface (CLI) or another third-party tool.

    Login to your PBI account using the pbilogin command.

    Navigate to the PBI file in question and run the following command :

    pbi get-metadata --file <PBIX filename> --output <output filename>

     

    With Tabular Editor : after loading the model, right-click on the "Model" node in the tree view and select "Export" -> "Document as JSON" from the context menu.

     

    With Power BI Helper : After loading your data go to the Model Info Tab and choose the metadata you want to extract (tables,measures, calculated columns..) > Export to CSV