No data sources for Scheduled Refresh with Azure DevOps connector

[RossJ]

I'm trying to set up a scheduled refresh on my report.  When I go to Manage > Scheduled Refresh, the Data sources tab is disabled, and the Scheduled refresh tab says "Scheduled Data Refresh is not available for reports. The report does not have any external data connections defined or is using an unsupported data source. Learn more".

Unlike this question, I'm not using a REST API. I'm using the built-in "Azure DevOps (Beta)" data source. Our DevOps instance is in the cloud, and our Power BI instance is on-prem. Our Power BI server version is May 2019, and my Desktop version is January 2019. I'm authenticating using a Personal Access Token (PAT).

There are only three queries in the report: two that use Analytics views, and one that is a dynamic ListGenerator without any sources.

I can refresh the report locally.

Any ideas?

[RossJ · Accepted solution]

I managed to get my report to schedule refresh by moving it from the on-prem server to the Power BI cloud. Either there is something wrong with our on-prem server, or the DevOps connection is supported in later versions, but it's working for me now.

[Anonymous]

Hi Ross,

Were you able to add additional data sources to the report you have? I'm getting an error that I can't have other data sources in the same report where I'm connecting to a live dataset in the Power BI service.

Thanks,

Jenny

[mhotek1]

It's not possible.  Your only method is manual refreshes for anything coming out of Azure DevOps.

[RossJ]

Thanks, @mhotek1. It doesn't seem to be limited to Azure DevOps though. I have other reports that use web APIs to import data from different sources, and I can't get them to automatically refresh either.

[mhotek1]

Neither can we.  We have Azure DevOps mixed with SQL Server data, which forces us to use Import instead of Direct Query.  The SQL Server data will refresh, the Azure DevOps data will not.  We can't schedule a refresh, we can't even manually refresh it on the server.  Our "refresh" is done by someone logging in every morning, downloading to PowerBI Desktop, hitting refresh, and then publishing it back to the server.

We have to do this with Azure DevOps and any other web APIs.  The only thing the PowerBI Report Server seems capable of refreshing either manually via the Refresh button on the report or scheduled is when its a SQL Server database.  No other data sources we are using will refresh except within PowerBI Desktop.

[NealSivley]

Ditto! I have a similar setup. I am not able to update my DevOps data via my onprem PowerBi Server. 

[RossJ]

Bump

[RossJ]

Anyone?