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

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

7 Replies

  • 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

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

     

    • v-xiaotang's avatar
      v-xiaotang
      Community Support
      4 years ago

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

    • v-xiaotang's avatar
      v-xiaotang
      Community Support
      4 years ago

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

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