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

Question

Hi,&nbsp;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.&nbsp;But is there any workaround to solve this problem?&nbsp;Tks_

jferrer · Answer

Hi Anonymous,&nbsp;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:&nbsp;&nbsp;

anonymous · Answer

hi&nbsp;Jferrer&nbsp;,&nbsp;Here on the forum there is a post saying that the automatic refresh with Sharepoint does not work.&nbsp;But anyway, put your settings here like this:&nbsp;&nbsp;tks

jferrer · Answer

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 · Answer

I'm using Sharepoint "Folder" and you "List", is this the problem?I'm querying some Excel XLSX.&nbsp;

jferrer · Answer

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:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

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

9 Replies

Related content

Mirroring from on-premise PostgreSQL and MySQL sources

Power BI Service on-premises gateway

On-premises data gateways

Setting up data source on power bi on-premise server with sharepoint

On-premise date Gateway