Dataverse MCP Server configuration failed...

If you want to configure the Dataverse MCP Server as described in the official Microsoft Learn article, you'll need to write in your mcp.json file an url with the following exact format (without the line breaks, of course):

https://make.powerautomate.com/environments/
59fd5b0e-f1e3-4f86-920d-509f44cb1846/connections
?apiName=shared_commondataserviceforapps
&connectionName=263a3d1e-1279-45f6-a593-070f9efaaad3

The tutorial instructs you to create a connection via make.powerautomate.com, and then take the URL from the connection page.

If you do it exactly as stated in the official docs, the URL you'll get has this form:

https://make.powerautomate.com/environments/
59fd5b0e-f1e3-4f86-920d-509f44cb1846/connections
/shared_commondataserviceforapps
/263a3d1e-1279-45f6-a593-070f9efaaad3/details

The fact is that URL, put in the mcp.json file, won't work 😡🤬.

You need to tweak the url manually in the following way:

• take the first part of the url, from https:// to connections
• replace the / after connections with ?apiName=
• replace the / after shared_commondataserviceforapps with &connectionName=
• remove the leading /details

And you're ready to go.

🙏🏻 Hope this helps you too!