How to enable scheduled refresh for PBI which connects to Azure DevOps?

[xiaohongt]

Hi,

I want to enable scheduled refresh on PBI which connects to Azure DevOps data, currently I can't enable it on PBI service, is it just a permission issue to enable it? or do I install data gateway to enable scheduled refresh?

thanks in advance

[v-cazheng-msft · Accepted solution]

Hi @xiaohongt,

If you are using cloud Azure DevOps, then Gateway isn’t necessary. To enable Scheduled refresh for the dataset, you need edit your credentials firstly. Could you please try to update credentials in Data source credentials and let me know whether you will get any error or configure Scheduled refresh successfully? Thanks in advance!

Best Regards,

Community Support Team _ Caiyun

[v-cazheng-msft · Accepted solution]

Hi @xiaohongt,

We get informed that here is a known issue(ICM 307200975) that Power BI customers using Azure DevOps may experience issues connecting from desktop. Users who already have connection established and report published to service might experience credentials errors when refreshing the dataset in the service. Product group is working on the fix. I’ll follow up this issue and sync here once there is any update. Thanks for your understanding!

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know how your tables look like, the relationships you create for them and how you create these two count measures. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[v-cazheng-msft · Accepted solution]

Hi @xiaohongt,

If you are using cloud Azure DevOps, then Gateway isn’t necessary. To enable Scheduled refresh for the dataset, you need edit your credentials firstly. Could you please try to update credentials in Data source credentials and let me know whether you will get any error or configure Scheduled refresh successfully? Thanks in advance!

Best Regards,

Community Support Team _ Caiyun

[helpmeplease112]

I am currently using Azure DevOps Server, and I am not able to enter any Data Source Credentials. Could you please help me @v-cazheng-msft ? It would be much appreciated 😁