Forum Discussion
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...
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.