Forum Discussion
Connection s issue with Power bi server
Hello, i have a simple query to one of my excel file in sharepoint online. let Source = Excel.Workbook(File.Contents("\\Sharepoint@ssl\web\test.xlsx"),null,true) in Source I am able to ...
Hi benneo ,
The connection string used in Power BI Desktop might need to be adjusted for Power BI Report Server. Normally, to connect to SharePoint Online using SSL, you may need to use the SharePoint Online List connector instead of directly pointing to the file path.
The proper format for SharePoint Online connection strings often starts with rather than a file path.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.