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

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

Anonymous — Thu, 24 Feb 2022 16:03:21 GMT

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 solve this problem?

Tks_

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

Jferrer — Thu, 24 Feb 2022 19:30:09 GMT

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:

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

Anonymous — Thu, 24 Feb 2022 20:01:51 GMT

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

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

Jferrer — Thu, 24 Feb 2022 20:01:59 GMT

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:

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

Anonymous — Thu, 24 Feb 2022 20:12:16 GMT

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

I'm querying some Excel XLSX.

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

Jferrer — Thu, 24 Feb 2022 20:21:02 GMT

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:

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

Anonymous — Fri, 25 Feb 2022 15:14:04 GMT

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.

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

v-luwang-msft — Tue, 01 Mar 2022 07:49:01 GMT

HI Anonymous ,

Based on your description, you encountered a problem when trying to connect SharePoint to File Explorer.

When you connect SharePoint to File Explorer, you need to meet some conditions, may I confirm whether you have fulfilled these conditions in this article?

About one of the conditions, since you mentioned that you have already add the link to the "Trusted Sites", we also recommend that you can add the following links to it:

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

v-luwang-msft — Fri, 04 Mar 2022 09:07:46 GMT

Hi Anonymous ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

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

Jferrer — Tue, 05 Apr 2022 14:16:52 GMT

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.