topic Re: Connection s issue with Power bi server in Report Server

Connection s issue with Power bi server

benneo — Mon, 29 Jan 2024 06:03:20 GMT

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)

Source

I am able to manually refresh and update my data. However when i upload to my report server, the connection string shows

Connection Type: File

Connection String: \\Sharepoint\web\test.xlsx

The @ssl is missing from the connection string. Thus, i am unable to schduled refresh my data in the report server. Is there any way to resolve this?

Re: Connection s issue with Power bi server

lbendlin — Mon, 29 Jan 2024 22:11:23 GMT

What made you use the file connector? The SharePoint Folder connector is so much more flexible.

Re: Connection s issue with Power bi server

Anonymous — Tue, 30 Jan 2024 02:27:35 GMT

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.

Re: Connection s issue with Power bi server

josef78 — Sun, 04 Feb 2024 21:58:26 GMT

WebDav access to on-premise Sharepoint is not supported on PBI RS. Use "Web" connector with HTTP/HTTPS URL to sharepoint stored file