Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Automatic report Refresh in Power BI Report Server with Sharepoint On-Premise

Hi,   I have a report in Power BI Report Server and it has a connection to Sharepoint On-Premise, I know that it is not possible to schedule an automatic refresh.   But is there any workaround to...
Report Server Data Refresh
Jferrer's avatar
Jferrer
Helper I
4 years ago

Hi Anonymous,

 

You should be able to schedule a refresh using the subscriptions on the report server site. This dashboard is connecting to a an on-premises sharepoint list. See below:

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    hi Jferrer ,

     

    Here on the forum there is a post saying that the automatic refresh with Sharepoint does not work.

     

    But anyway, put your settings here like this:

     

     

    tks

    • Jferrer's avatar
      Jferrer
      Helper I
      4 years ago

      Here is how it is set up on PowerB Desktop. This data source is pointing to a sharepoint list. Make sure that the account you are using to connect to sharepoint has atleast read permissions. The sharepoint admin can do that.

       

      I am using Report Server Sept 2021 version.

       

       This is how it shows up in Report Server:

       

       

       

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I'm using Sharepoint "Folder" and you "List", is this the problem?

        I'm querying some Excel XLSX.