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

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.

 

 

  • Jferrer's avatar
    Jferrer
    Helper I
    4 years ago

    Is it an excel file that is in a sharepoint folder? If so, you can just select an Excel data source and url path to it like below:

     

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      yes, I have several Excel files in a folder on Sharepoint.

      I tried to create an Excel data source but when I put the folder URL the following message is displayed.

       

       I already add the SharePoint site URL to Trusted Sites list, but the error remains.

       

      • Jferrer's avatar
        Jferrer
        Helper I
        4 years ago

        Do you have access to view that spreadsheet with the account you are currently opening PowerBi with? It seems that the account you are trying to connect to the excel sheet with does not have access.