cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mrquestionmark Frequent Visitor
Frequent Visitor

Azure DevOps Server data source refreshing in PBI on-premise server

I have a DevOps on-premise server and using Azure DevOps Server data source developed a PBI report. But when I deployed the report to my on-premise PBI server. I do not know how to refresh it. There is no Data Source security setup and data refrehsing setup in server side. What is the concept here? should I assign ssrs service account access to DevOps and the report will be refreshed by clicking refresh button?

 

Thanks in advance

7 REPLIES 7
Community Support Team
Community Support Team

Re: Azure DevOps Server data source refreshing in PBI on-premise server

Hi @Mrquestionmark ,

If you want to configure schedule refresh, you need to publish it to web portal.  In the Desktop, you only can refresh manually by the button. For more details, please view the document below.

How to configure Power BI report scheduled refresh 

 

Best Regards,

Xue Ding

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

Mrquestionmark Frequent Visitor
Frequent Visitor

Re: Azure DevOps Server data source refreshing in PBI on-premise server

Hi Xue,

 

Thanks for your quick response. I did deployed it to my on-Premise pbi server but there was no data source security setup for this data source.  What is the concept here? should I assign ssrs service account access to DevOps and the report will be refreshed by clicking refresh button?

Mrquestionmark Frequent Visitor
Frequent Visitor

Re: Azure DevOps Server data source refreshing in PBI on-premise server

@v-xuding-msft 

Hi Xue,

 

Thanks for your quick response. I did deployed it to my on-Premise pbi server but there was no data source security setup for this data source.  What is the concept here? should I assign ssrs service account access to DevOps and the report in ssrs web portal will be refreshed by clicking refresh button?

moelsaied88 Frequent Visitor
Frequent Visitor

Re: Azure DevOps Server data source refreshing in PBI on-premise server

I'm having this exact same issue. When I check the refresh history of the report, I see the below error. This is driving me up a wall trying to figure it out.

 

SessionID: 7c35e4e9-64df-42d8-8a8c-6a3fad1f6a1f

[0] -1055784932: The import AzureDevOpsServer.AnalyticsViews matches no exports. Did you miss a module reference?. The exception was raised by the IDbCommand interface.

[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

Highlighted
moelsaied88 Frequent Visitor
Frequent Visitor

Re: Azure DevOps Server data source refreshing in PBI on-premise server

@v-xuding-msft 

 

Any guidance you can share on how to get the Azure DevOps Server connector to work with a report on Power BI Server would be greatly appreciated.

Mrquestionmark Frequent Visitor
Frequent Visitor

Re: Azure DevOps Server data source refreshing in PBI on-premise server

@v-xuding-msft 

 

I am using PowerBI Desktop Janurary 2019 on-premise. I can refresh the data in Desktop no problem.

 

But when I deployed it to server, as you can see below, data source greyed out and I could not set up data refresh schedule. What is the concept here? is it a live data source? no need to set up the schedule? which credential is using for the data source?

 
Mrquestionmark Frequent Visitor
Frequent Visitor

Re: Azure DevOps Server data source refreshing in PBI on-premise server

1.png2.png3.png4.png

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)