ALM Toolkit Invalid Key-Value Set

[bbadco]

When trying to compare my local dataset with what I have online using ALM Toolkit, it returns me error:

'provider=msolap;Data source=powerbi://api.powerbi.com/v1.0/myorg/Workspace%20Name;Initial Catalog=Dataset Name;' is an invalid key-value set. parameter name; keyvalueset

Steps I took: 

Copied local server link > pasted in source workspace and selected dataset > Copied connection link from workspace settings> pasted in target workspace and selected dataset> Error

I triple checked spelling and assured that I am using the correct links for each workspace. Is there a workspace, tenant, or even semantic model setting that needs to be switched to address this error?

Looking for an explanation for the error and a direction towards a solution to avoid this error.

Thanks

[christianwade]

Hi, are you including those connection string params in the workspace text box? It needs to be just the XMLA server URL:

[bbadco]

The initial catalog name had an apostrophe/single quote in it, which confuses the internal mechanism that parses the workspace link and dataset name.

I realize that a better example to have used in my initial post would be:

'provider=msolap;Data source=powerbi://api.powerbi.com/v1.0/myorg/Workspace%20Name;Initial Catalog=Dataset's Name;' is an invalid key-value set. parameter name; keyvalueset

In the case that the semantic model or dataset name cannot be changed and has an apostrophe in it you can replace the apostrophe with a unicode " %27 " and it should work.