Forum Discussion

Max_25's avatar
Max_25
Regular Visitor
1 year ago
Solved

Delete all data for measure cleanup

Hi everyone,   Situation: I am new to PowerBI and got a really huge dashboard file from a colleague who left. The file has a lot of measures from which I suspect most are not in use anymore and I...
Data Protection
Tips and Tricks
Tutorial Requests
  • rohit1991's avatar
    rohit1991
    1 year ago

    Hi Max_25 

     

    The right way to do this is to export your report as a Power BI Template (.pbit).

    • In Power BI Desktop, go to File > Export > Power BI template.

    • A .pbit file keeps all the report structure (pages, visuals, relationships, measures, model) but removes all the loaded data.

    • When you open the .pbit on another PC, it will prompt for data connections, and you can then run tools like Power BI Helper or DAX Studio there to clean up unused measures.

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

Hi Max_25 

 

The right way to do this is to export your report as a Power BI Template (.pbit).

  • In Power BI Desktop, go to File > Export > Power BI template.

  • A .pbit file keeps all the report structure (pages, visuals, relationships, measures, model) but removes all the loaded data.

  • When you open the .pbit on another PC, it will prompt for data connections, and you can then run tools like Power BI Helper or DAX Studio there to clean up unused measures.