Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dataverse Connector - Connect to Dynamics CRM, Scope Error

klambert
7 - Meteor

I am trying to connect to Dynamics CRM, I have followed the set up instructions on the dataverse connector however I am getting the following error:

 

"The provided request must include a 'scope' input parameter. The provided value for the input parameter 'scope' is not valid."

klambert_1-1651738598115.png

 

I have gone into the app registration and tried to add the scopes in the format:  api://<Application ID URI>/openid for example, but I am still getting this error. Has anyone had any success with this connector?

5 REPLIES 5
VojtechT
Alteryx
Alteryx

Hi @klambert ,

could you share a printscreen of your auth page setting before you click the "Connect" button? The Dataverse requires to authentication to happen twice - the first time to obtain the list of available environments from the Dataverse tenant, then a second one to actually log in into that environment specifically. 

The error indicates that both of these steps did not happen. Is that possible?

Vojta T., PM for Data Connectors
Try our Beta data connectors at https://bit.ly/3Ae8HgY
klambert
7 - Meteor

Thank you @VojtechT !

 

This is the auth page before hitting connect:

 

klambert_0-1652432037766.png

 

It pops up with the login window, says I am connected but sits on loading for hours until eventually the error message pops up.

 

klambert_1-1652432106060.png

 

If I connect without "Use service principal" it connects fine and I can see the tables, but I would like to have the ability to schedule without having to keep logging in to collect the data.

 

Thank you!

VojtechT
Alteryx
Alteryx

If your intention is not to use the Service Principal, you should not have any Application level permissions in the Azure app. Could you verify that only Delegated ones are present? 

Vojta T., PM for Data Connectors
Try our Beta data connectors at https://bit.ly/3Ae8HgY
klambert
7 - Meteor

I do wish to use the service principal (I understand this is needed to avoid access expiring after 24 hours?), within Azure I have followed the process as detailed here:

 

https://help.alteryx.com/20221/designer/microsoft-dataverse

 

At the moment, it is successful connecting without the service principal but not with it. This is currently the set up with the API permissions:

 

klambert_0-1652447847777.png

 

VojtechT
Alteryx
Alteryx

Actually, the latest version of Dataverse connector - 1.1.0 - does not have this limitation and the user login is valid for 6 months, instead of the previous 24 hours. 

Setting up the Dataverse to use Service principal is little bit more tricky - did you create and assign also the role for the app? As described at the end of the page. 

Vojta T., PM for Data Connectors
Try our Beta data connectors at https://bit.ly/3Ae8HgY
Labels