Forum Discussion
Helper VDataset scheduled refresh fails with odata azure devops source
Hi there!
I have a report that i made, using an odata query to the azure devops environment. This was done because i wanted board columns and other items that are not available by creating an analytics view.
Now the issue is, that it will not refresh unless i am actually logged into my workspace.
I cannot find a workaround to this. Any suggestions?
Well, its an answer, but if acceptable... i don't think so, hence i won't mark any as such.
10 Replies
- BhavinVyas3003
Super User
Use a Power BI Dataflow instead of connecting directly in the report.
In Power BI Service, go to your workspace.
Click “New” → “Dataflow”.
Choose “Add new tables”, then select OData feed as the source.
Enter your Azure DevOps OData URL (e.g., https://analytics.dev.azure.com/{org}/_odata/v3.0-preview/).
Sign in using OAuth2 (Organizational account).
Select the tables and save the dataflow.
In Power BI Desktop, use “Power BI dataflows” as your source and connect to this data.
Publish the report. Scheduled refresh will now work from the dataflow.
decarsulI'll try create a dataflow, but honestly i do not see how authentication for a dataflow would be different from a dataset. Both are tied to my personal credentials, which seem to require an active AD user.
- BhavinVyas3003
You're right, both use your Azure AD credentials but dataflows handle authentication more reliably in the cloud. Once set up, the dataflow refreshes data independently, and your dataset connects to that refreshed data, avoiding direct login issues with Azure DevOps OData.
- V-yubandi-msft
Community Support
Hi decarsul ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
- decarsul
Well, its an answer, but if acceptable... i don't think so, hence i won't mark any as such.
- V-yubandi-msft
Hi decarsul ,
Thanks for the update. You're absolutely right to expect a workaround, and while Power BI doesn’t currently support scheduled refresh for Azure DevOps OData with a service principal. If there’s a specific workaround or approach you’re looking for ? Let us know .
Regards,
Yugandhar.
- V-yubandi-msft
Hi decarsul ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
