connecting to Excel file on Sharepoint using web address

[masplin]

Hi

I've got a model working fine using the locla path ot asharepoint excel file, but need ot switch it to the web version to publish. 

If i go to sharepoint online and copy the link i get this

https://cxxxxxxxxxxxxxxxxxxxltd.sharepoint.com/:x:/r/sites/PowerBIReporting/Shared%20Documents/Agenc... 

This just says url invalid. I chopped off the bit after xlsx and get request failed. I took out the :x/r/sites/ and get Web.Contents failed ot get contents form this but with a /$value on the end

Oddly if I look at sharepoint the folder is "Power BI Reporting" with spaces but this link has no spaces. Elsewhere ther spaces are replaced with %20.  i tried that and no better

So the question is what is the correct syntax to read an excel file  if the local path is U:\Sharepoint\CxxxxxxxxxxxxxxxxxxLtd\Power BI Reporting - Documents\Agency Fee Pattern to Sep20.xlsx

Thanks any advice as should be really simple

Mike

[masplin · Accepted solution]

Found it sorry. You have to get the url out of excel not out of sharepoint!!!

Excel.Workbook(Web.Contents(https://cxxxxxxxxxxxxxxxxxltd.sharepoint.com/sites/PowerBIReporting/Shared%20Documents/Agency%20Fee%...), null, true) works

[John-Serrano]

Hi I am trying to connect to a Excel file in a web page but  I can´t do it, please help.

http://portalbissrs.xm.com.co/hdrlg/_layouts/15/WopiFrame.aspx?sourcedoc={B3385EEE-113F-4105-ABD4-9B...

[masplin]

My issue was my data was stored in a Sharepoint location and I couldn't work out how to get power BI to conenct ot it. Where is your file being stored?