Automate Refresh for Azure Analytics Service causing issues using PAT (works on PowerBI Desktop)

[Anonymous]

Good day, 

I have an issue authenticating with a Azure DevOps PAT when connecting to an OData.Feed for our Azure Boards. 
The issue seems to be failing - even though the credentials are working fine (the PAT has been tested). 

When i try this on PowerBI Desktop, it works fine and refreshes the data and I am able to publish the dataset file. 

In a nutshell we have multiple projects so we have to use this URL for the data feed (with some filters)

https://analytics.dev.azure.com/{orgName}/_odata/v3.0-preview/WorkItems

Which we then create a table from and then run our reports from. 

I have tried the Basic (username + PAT) - but I get an unsuccesful loging,  trying an OAuth2 credential also seems to fail. 

Any help would be appreciated? 

Thank You 

[Anonymous · Accepted solution]

It might be that we need to create an Azure service account - as we have some Conditional Access policies on our Azure side. 

dont think this issue is on PowerBI side. 

you can close this for now

[Anonymous]

Hi, Did you find any solution for the conditional access policy ? We too have the same problem and didnt find any solution yet. Thanks.

[v-xiaotang]

Hi @Anonymous 

Thanks for your reply. If you have other question, you can recreate the post and we'll help you in time. ❤️

Now could you accept the answer as solution to close this thread? Thanks again  🙂

Best Regards,

Community Support Team _ Tang

[Anonymous]

just to add to this,  i am getting an "invalid credentials" error 
even though those credentials work on the PowerBI desktop file.

[v-xiaotang]

Hi @Anonymous 

Thanks for your reply, I saw the author has replied to you, does it help?

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you @v-xiaotang 

So the issue is that the OData feed works on the PowerBI desktop
using the feed https://analytics.dev.azure.com/{orgName}/_odata/v3.0-preview/ 

And if i use a Basic authentication value for my username and a PAN token, then it works.  OAuth2 also works on Desktop.
The issue only happens when the pbix is published to PowerBI workspace and we try and validate the credentials there. 
This is so that we can enable the dataset refresh from within PowerBI and not have to do it manually. 

I think the issue is with the connection from PowerBI Workspace to Azure for the analytics part. 
Not sure if someone has this working, or if I have configured this incorrectly. 

I pretty much followed the instructions from

https://sqlitybi.com/connecting-power-bi-to-azure-devops-using-odata-feed/?doing_wp_cron=1592467600....

[v-xiaotang]

Hi @Anonymous 

not sure how to reproduce this problem, could you share the screenshot without sensitive information?

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.