Forum Discussion

Mrquestionmark's avatar
Mrquestionmark
Helper I
6 years ago

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

Need Help

11 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    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's avatar
      Mrquestionmark
      Helper I
      6 years ago

      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's avatar
        Mrquestionmark
        Helper I
        6 years ago

        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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      @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's avatar
        Mrquestionmark
        Helper I
        6 years ago

        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?

         
  • Msaeed90's avatar
    Msaeed90
    Frequent Visitor
    4 years ago

    I have the same issue 
    is there any solution even by connecting to the REST API of azure DevOps instead of the analytics views?