Power BI Auto Refresh AzureDevOpsServer not supported error

[AMZBrandon]

Error for Power BI Auto Refresh on the web:
I can connect to my data and work from the Power BI desktop app and can refresh the data from Azure DevOps just fine. After publishing the report to the Power BI workspace (web) I cannot set a refresh schedule and get the following

error:
"Unable to determine the data source due to unknown functions. When custom connectors are used, the error can happen if gateway doesn't have the extension enabled. Details: Query contains unknown function name: AzureDevOpsServer.AnalyticsViews.
Data source for Query1"
You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
Data source for Query1

-We are using a personal access token to connect to the dataset.

-In the Power BI desktop app we chose the "Azure DepOps Server (Boards Only)"

I don't think that Azure DevOps needs a gateway as I have created reports before and never needed to set one up unless this is a different gateway that's external.

Is this an issue within Azure DevOps that we need to fix or is this something on the Power BI side?

[Anonymous]

Hi @AMZBrandon ,

You can try to update the gateway to the latest version try.

Below is the same case you can ferret out:

Solved: Refresh error from AzureDevOpsServer - Microsoft Fabric Community

Best Regards,

Xianda Tang

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

[AMZBrandon]

Never needed a gateway in the past that I know of just using the Azure DevOps connector? Is that something that needs to be setup somewhere? 

This is how I'm connected and the Power BI desktop can refresh data just fine, after publishing to the web i get the error that I cannot set up the auto-refresh.

https://learn.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devo...

[marcel_ncrdb]

Hi @AMZBrandon ,

Did you manage to resolve your issue with Microsoft?

I'm encountering a similar problem. I am unable to configure the Azure DevOps server in the Power BI service. Every time I try, it redirects me back to the manual add gateway page.

[Anonymous]

Hi @AMZBrandon ,

If your organization uses firewalls or proxy servers for security, you'll need to add certain Internet Protocol (IP) addresses and domain Uniform Resource Locators (URLs) to your allowlist to ensure that you can access Azure DevOps on your network.

Best Regards,

Xianda Tang

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

[lbendlin]

did you submit the ticket?

[lbendlin]

sounds more like an issue on the DevOps side

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .