connect bi desktop to excel file uploaded in SP Doc library

[marial16]

Hallo,

I uploaded 2 excel files in SP Doc Library (format as table).

I chose get data and i entered the Library url.

How can i access data in  the worksheet? 

Thank you

[marial16]

thank you for your answer, I tried a different approach using a sharepoint List, since i couldn't do the filtering as i wanted.

[v-chenwuz-msft]

Hi @marial16 ,

Have your problem been solved? If yes, please mark it as solution so that some one have the same problems as you will find the answer quickly.

If no, maybe you can refer this article.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links 

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Thejeswar]

Hi,

You can also try using the connector for "Sharepoint Online List". 

The Excels in sharepoint are similar to the Sharepoint Lists.

So I think this should help you import the files into Power BI. 

[MikeJohnsonZA]

Were you able to try this out.

I was not able to content to any Excel files using this but maybe there is a trick to it?

[MikeJohnsonZA]

Hi

Connecting to Excel files in Sharepoint is not always intuitive, the way I do it is.

1) Open the Excel file from sharepoint

2) Select the [open in desktop app] button above the ribbon

3) when the Excel file opens select the [File] ribbon then select info.

4)  There is an option to [Copy Path] towards the top of the page. This will copy the URL of the page

5) in Power BI select [Get Data] and select the [Web] option

6) paste the URL from step 4 into the URL but delete the bit at the end  '?web=1'

7) if you are prompted to authenticate then select the [organisational account] option.

This will connect you to the excel file hosted in SharePoint.