I built the application using MS Build.
I got AlmToolkit.exe file. When I run that application I got an error saying

A connection cannot be made. Ensure that the server is running.

So I'm confused about the server which is being displayed in the error message.
What all should I be doing to run this ALM application and compare 2 PowerBI files?

Please Help!!

Hi,

I got an error and will be grateful for help:

Power-BI-ALM-Toolkit-master\BismNormalizer\BismNormalizer.csproj(534,11): error MSB4226: The imported project "C:\Program Files (x86)\Microsoft Visual Studio\2017\SQL\MSBuild\Microsoft\VisualStudio\v15.0\VSSDK\Microsoft.VsSDK.targets" was not found. Also, tried to find "VSSDK\Microsoft.VsSDK.targets" in the fallback search path(s) for $(VSToolsPath) - "C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v15.0" . These search paths are defined in "C:\Program Files (x86)\Microsoft Visual Studio\2017\SQL\MSBuild\15.0\Bin\MSBuild.exe.Config". Confirm that the path in the declaration is correct, and that the file exists on disk in one of the search paths.

Is it possible to use this tool to compare power bi datasets that are made in PBI (Not analysis services)? If so, what should I put as workspace in source/target?

Is it possible to use BISMNormalizer or any other tool to get diff on power bi data models? I see newest Tabular Editor has partial support for .pbit, but no diff....

Could you please add a brief description of this project to the readme, or a link to an existing description? Thanks!

I believe I downloaded and installed all the necessary components in order to try and build the code to try this out. I am getting the following errors:

Error CS0234 The type or namespace name 'RibbonTab' does not exist in the namespace 'System.Windows.Forms' (are you missing an assembly reference?) AlmToolkit C:\Users\englida\Downloads\Power-BI-ALM-Toolkit-master\Power-BI-ALM-Toolkit-master\AlmToolkit\ComparisonForm.Designer.cs

Error CS0234 The type or namespace name 'RibbonPanel' does not exist in the namespace 'System.Windows.Forms' (are you missing an assembly reference?) AlmToolkit C:\Users\englida\Downloads\Power-BI-ALM-Toolkit-master\Power-BI-ALM-Toolkit-master\AlmToolkit\ComparisonForm.Designer.cs

Error CS0234 The type or namespace name 'RibbonButton' does not exist in the namespace 'System.Windows.Forms' (are you missing an assembly reference?) AlmToolkit C:\Users\englida\Downloads\Power-BI-ALM-Toolkit-master\Power-BI-ALM-Toolkit-master\AlmToolkit\ComparisonForm.Designer.cs

Error CS0234 The type or namespace name 'Ribbon' does not exist in the namespace 'System.Windows.Forms' (are you missing an assembly reference?) AlmToolkit C:\Users\englida\Downloads\Power-BI-ALM-Toolkit-master\Power-BI-ALM-Toolkit-master\AlmToolkit\ComparisonForm.Designer.cs

Error CS0234 The type or namespace name 'RibbonOrbMenuItem' does not exist in the namespace 'System.Windows.Forms' (are you missing an assembly reference?) AlmToolkit C:\Users\englida\Downloads\Power-BI-ALM-Toolkit-master\Power-BI-ALM-Toolkit-master\AlmToolkit\ComparisonForm.Designer.cs

Error CS0234 The type or namespace name 'RibbonArrowDirection' does not exist in the namespace 'System.Windows.Forms' (are you missing an assembly reference?) AlmToolkit C:\Users\englida\Downloads\Power-BI-ALM-Toolkit-master\Power-BI-ALM-Toolkit-master\AlmToolkit\ComparisonForm.Designer.cs

Am I potentially missing a step or an additional reference someplace? Is there a particular version of the .NET framework we should be targeting?

Also, will this tool strictly be for the data model portion, will it ever be able to detect changes in the reports as well to push changes. We use Live Connections to Analysis Services, so when it comes to Power BI this tool won't do much for us from what I can tell. Looks like primarily for users that use imported models or possibly DirectQuery.

Thanks.

I click Compare, fill in the workspace URL and (after providing Azure credentials) dataset names in the Connections dialog, and click Okay.

I shortly get this dialog

upon which I click Yes and then wait a bit as it says "comparing datasets..." at the bottom.

Then it changes to "finished comparing datasets" but I don't see the diff editor from the marketing page; that part of the window remains blank.

I do see the Select Actions, Validate Selections, and Report Differences buttons light up; some of which even work.

• Report Differences seems to work perfectly; the resulting spreadsheet describes the changes I expected to see.
• Select Actions shows a dropdown of things I can't make much informed use of without the diff editor.
• Validate Selections seems to get all the way through "Data Sources", but as soon as it starts on "Tables" there's an unhandled exception:

System.NullReferenceException: Object reference not set to an instance of an object.
   at BismNormalizer.TabularCompare.TabularMetadata.Table.DeleteRelationship(String internalName) in C:\Users\Kyle Fiegener\Dev\• Sprints\2019-06-14 Add Orcas\Power-BI-ALM-Toolkit\BismNormalizer\TabularCompare\TabularMetadata\Table.cs:line 232
   at BismNormalizer.TabularCompare.TabularMetadata.Table.DeleteAllAssociatedRelationships() in C:\Users\Kyle Fiegener\Dev\• Sprints\2019-06-14 Add Orcas\Power-BI-ALM-Toolkit\BismNormalizer\TabularCompare\TabularMetadata\Table.cs:line 189
   at BismNormalizer.TabularCompare.TabularMetadata.TabularModel.DeleteTable(String name) in C:\Users\Kyle Fiegener\Dev\• Sprints\2019-06-14 Add Orcas\Power-BI-ALM-Toolkit\BismNormalizer\TabularCompare\TabularMetadata\TabularModel.cs:line 412
   at BismNormalizer.TabularCompare.TabularMetadata.TabularModel.UpdateTable(Table tableSource, Table tableTarget, String& retainPartitionsMessage) in C:\Users\Kyle Fiegener\Dev\• Sprints\2019-06-14 Add Orcas\Power-BI-ALM-Toolkit\BismNormalizer\TabularCompare\TabularMetadata\TabularModel.cs:line 460
   at BismNormalizer.TabularCompare.TabularMetadata.Comparison.UpdateTable(ComparisonObject comparisonObject) in C:\Users\Kyle Fiegener\Dev\• Sprints\2019-06-14 Add Orcas\Power-BI-ALM-Toolkit\BismNormalizer\TabularCompare\TabularMetadata\Comparison.cs:line 1524
   at BismNormalizer.TabularCompare.TabularMetadata.Comparison.ValidateSelection() in C:\Users\Kyle Fiegener\Dev\• Sprints\2019-06-14 Add Orcas\Power-BI-ALM-Toolkit\BismNormalizer\TabularCompare\TabularMetadata\Comparison.cs:line 741
   at AlmToolkit.WarningListForm.WarningListForm_Shown(Object sender, EventArgs e) in C:\Users\Kyle Fiegener\Dev\• Sprints\2019-06-14 Add Orcas\Power-BI-ALM-Toolkit\AlmToolkit\WarningListForm.cs:line 49
   at System.Windows.Forms.Form.OnShown(EventArgs e)
   at System.Windows.Forms.Form.CallShownEvent()
   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

Also of note: I've gone through the Compare process about 3 times now to gather information about the issue, and each time for the same two datasets it has shown the "Power BI datasets have default data-source versions of PowerBI_V1 ..." dialog; suggesting that the upgrade to PowerBI_V3 is not taking place.

I'm having trouble to connect to my local pbix files and the application reports an error message saying:
Analysis Server localhost:60343 is not running in Tabular mode

Both Source and Target files are open and I have verified that I actually can connect to the local workspaces using SSMS