Alteryx Server writing to Dataverse

Question

I have created a flow that runs fine in Designer on the server VM itself, but when I deploy to server it fails to run with error: "Provided Azure application does not have required permissions for scheduling. Either disable 'use service principal' or provide an Azure app with required permissions and login again"

I am leveraging an AppRegistration in Azure and Service Principle as connection option.

Anyone be able to get this to work?

markashman · Answer

Hi, sorry only just had chance to look at this. If I do not use the SP then I would need to provide login credentials, so we would need to provide a specific user with relevant access which to me seems less secure and would be more challenging to get through our Information Security approval process. However, are you suggesting if this approach is taken the connection will not timeout, so can be run in Gallery a day later for example?

fmvizcaino · Answer

Hey @markashman ,

There is a use service principal checkbox on the connector that you may need to deactivate. It`s either this or an Azure permission that is missing and the video I`m sharing below might help you identify it.

When I connected to Dataverse, I used this youtube video and was able to connect. https://www.youtube.com/watch?v=xS3bWwp-s8o

Best,

Fernando Vizcaino