Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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 ...
Dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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.9906818866729736328125