Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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_
Hi @kenymaciel ,
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
HI @kenymaciel ,
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:
Similar questions refer:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi @kenymaciel,
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:
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
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:
I'm using Sharepoint "Folder" and you "List", is this the problem?
I'm querying some Excel XLSX.
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:
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.
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.
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |