Forum Discussion
ALM Toolkit Invalid Key-Value Set
Issue Resolved:
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.
Hi jbirco , Thank you for reaching out to the Microsoft Community Forum.
This error in ALM Toolkit usually happens because of a problem with the XMLA connection string used to connect to your Power BI (Fabric) workspace. ALM Toolkit connects through the XMLA endpoint and even small formatting issues in the connection string can cause this error.
Make sure the workspace you’re connecting to is in a Premium, Premium Per User (PPU) or Fabric capacity, ALM Toolkit won’t work with standard workspaces. Then, copy the XMLA endpoint directly from your workspace settings in Power BI, but use it exactly like this: powerbi://api.powerbi.com/v1.0/myorg/Workspace Name
Don’t include provider=msolap and don’t replace spaces with %20. The dataset (Initial Catalog) should be selected inside ALM Toolkit, not added to the connection string.
Also, confirm that the workspace has XMLA endpoint access enabled (Read/Write) under workspace settings and that you’re using the latest version of ALM Toolkit. Older versions may not support Fabric datasets or the current XMLA syntax.
Issue Resolved:
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.