Forum Discussion
Comparing two Semantic Models
Is there a way to take two semantic models and compare them for differences in applied steps? Kind of like you can compare two Word documents for changes?
Hi DPCCGF,
Thank you for reaching out in Microsoft Community Forum.
Please follow below steps for take two semantic models and compare them for differences in applied steps;
1.Please Use Tabular Editor to open both models and visually compare tables, measures, and M code (Tabular Editor 3 supports side-by-side diff).
2.Use ALM Toolkit to compare two Power BI datasets (published or local) and see detailed differences in schema and definitions.
3.Export models as .pbit or extract metadata to JSON, then compare using diff tools like WinMerge or Beyond Compare.
4.Try Power BI Helper to analyze and compare model metadata, including applied steps and dependencies.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
7 Replies
You seem to be describing the Git integration features of Power BI with PBIR and TMDL options. Have you tried any of these?
Hi DPCCGF,
Thank you for reaching out in Microsoft Community Forum.
Please follow below steps for take two semantic models and compare them for differences in applied steps;
1.Please Use Tabular Editor to open both models and visually compare tables, measures, and M code (Tabular Editor 3 supports side-by-side diff).
2.Use ALM Toolkit to compare two Power BI datasets (published or local) and see detailed differences in schema and definitions.
3.Export models as .pbit or extract metadata to JSON, then compare using diff tools like WinMerge or Beyond Compare.
4.Try Power BI Helper to analyze and compare model metadata, including applied steps and dependencies.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.Hi i can't find any documentation on using Tabular Editor 3 for comparison of two files, are you able to link me to anything?
My company does not allow ALM toolkit so I looking for a substitute.
Thanks 🙂
With TE3 you need to use your eyeballs to do the comparison.
Did the company give a reason for disallowing ALM Toolkit, but allowing TE3 ? I would have thought the other way round makes more sense.
Hi DPCCGF,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.
Thank you,
Pavan.Hi DPCCGF,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept as Solution" and give it a 'Kudos' so others can find it easily.
Thank you,
Pavan.Hi DPCCGF,
I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.
Thank you,
Pavan.
