PBIX reports comparison

[AmudhaKumaran]

I'm trying to find the differences between 2 PBIX reports (measures, visuals, filters, etc.,). I have validated the models using ALM toolkit. Is there any simple option to compare 2 PBIX reports as I have many files to be compared? Any quick response would be of great help.

[lbendlin · Accepted solution]

No need to convert anything. Open the pbix with your ZIP viewer of choice, or unpack it with Powershell.

[lbendlin]

You are already doing the comparison via ALM Toolkit.  Is that not simple enough?

You can run custom TMSL code if you like Tabular Model Scripting Language (TMSL) Reference | Microsoft Docs

For visual level comparisons you can unpack the .PBIX files (they are ZIP archives) and compare the "Report"  sections.

Especially the Layout file

Use a JSON parser for that.

[AmudhaKumaran]

Hi Ibendlin

Thanks for your quick response. I have converted my PBIX file to a Zip file. But when I double click, I'm not able to get into the below view.

Am I missing something here?