Why can't I import Excel from Sharepoint

[PatrickByGecko]

Hello

I want to add an new excel sources from a sharepoint site (on the cloud) as  a new table in power bi but I can't indicate this source except if the excel file is on  my PC.  Do not understand.

[Anonymous · Accepted solution]

@PatrickByGecko 

Here is the step by step process:

• Select "sharepoint folder" under "get data". Paste your sharepoint home page URL. Click OK.
• In the window, you will see all the list of files names in document library available in your site.
• Select "transform data"
• Edit query window appears. You will see the details of your files and there will be "Binary" in first or second column. Click on that Binary option.
• It opens the data in that file. Now either clkick on transform data or load it directly.

Pls mark this as "ascepted solution" and give a kudos if this solves your problem. 

[Anonymous]

If the excel is in asharepoint site/folder (cloud) then you will have to select the source as sharepoint folder. It wilkl display the files in that folder and you can click on table adjacent to that file to select it.

If you find the solution helpful, do mark this as solution and give a kudos.

[PatrickByGecko]

Underneath you can see where is my excel files in sharepoint cloud and the message I get when I try to give the Url of the sharepoint site in power Bi desktop...

😞

I don't see my excel files underneath..

[coco83]

Hello,

did you finally found a solution? I cannot see my excel files either, it's driving me crazy...

[PatrickByGecko]

Here is a clearer screen shot. When I copy paste the Url of this excel files I get an error when Opening new source in Power bi Desktop... can you help?

[Anonymous · Accepted solution]

@PatrickByGecko 

Here is the step by step process:

• Select "sharepoint folder" under "get data". Paste your sharepoint home page URL. Click OK.
• In the window, you will see all the list of files names in document library available in your site.
• Select "transform data"
• Edit query window appears. You will see the details of your files and there will be "Binary" in first or second column. Click on that Binary option.
• It opens the data in that file. Now either clkick on transform data or load it directly.

Pls mark this as "ascepted solution" and give a kudos if this solves your problem. 

[PatrickByGecko · Accepted solution]

It works, thank you a lot and Bravo.

👍