Connecting existing Power BI to Sharepoint - different errors to access Sharepoint

[Anonymous]

Hi everyone, 

I am trying to connect a PowerBI existing file to an Excel file saved on my organization's sharepoint. 

I know the procedure (create a new file, copy link etc.) but I am struggling with accessing the Excel file saved on Sharepoint through Power BI. 

I am not the admin of the folder and I do only have access to tat specific folder, not to the contect of the previous stream pages. 

the link to the FILE I'm trying to reach is as follows:

https://xxx.sharepoint.com/:x:/r/sites/fileshare/departments/Desks/Spanish/Spanish%20Desk%20Call%20L...

Whilst, the link to the Sharepoint folder is:

https://xxx.sharepoint.com/:f:/r/sites/fileshare/departments/Desks/Spanish?csf=1&e=dixhJt

Now, if I copy this link down to Spanish or down to desks, I get the following message:

If I try to cut the line after "departments" I get a navigation panel where the underlying folders are reported as files, so I can't access them: 

So the question, how to I reach that file specifically? 

Thank you all!

Matteo

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

pls click the select box before the file you wanna reach where I have marked in a red line below.Then choose "Carica" or "Trasforma dati"to load or transform data.

Hope this would help.

Best Regards,

Kelly