Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
thomasreick
Resolver I
Resolver I

Empty Folder-Structure on get data from Sharepoint folder. Rights / Credential issue or sth else?

Hi all,

can somebody please comment on this:

I want to load data from an Excel-File located in a SharePoint-Folder.

In the Get-Data-Dialog I have entered what is, I think,  the requested root-folder.

All I receive is an empty list reflecting the structure of the folder (pls. see Screenshot, am I correct on this?)Empty Folder strucutreEmpty Folder strucutre

Is that an issue refering to user rights?

I received the path to the file. The file exists amongst other objects. But I cannot process it to PQ/PBI.

Kindliy asking for advice.

thx in advance

Thomas

2 ACCEPTED SOLUTIONS
DataInsights
Super User
Super User

@thomasreick,

 

Try using the Web connector (enter the full path, ending with .xlsx).





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

See if this helps:

 

https://ssbipolar.com/2018/10/29/power-query-connecting-to-excel-workbooks-in-sharepoint-online/ 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

5 REPLIES 5
thomasreick
Resolver I
Resolver I

Hi all,

thank you very much for the Hint given.

Meanwhile I check it accordingly @DataInsights Link/Hint and it works,... BUT

Ntl... I should see a list of folders/files when handing the base-Url to PBI, shouldn't I?

That is what I am expecting when reading from a SP-Folder, although there might be mixed filetypes e.g XLS*, *.PPTX, *.ACCDB.

So what is the root of the roginal issue?

 

ntl Solution is accepted, thank you very much

Thomas

 

DataInsights
Super User
Super User

@thomasreick,

 

Try using the Web connector (enter the full path, ending with .xlsx).





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




I tried, here is the error:

Markzolotoy_0-1636914517200.png

URL is up  to the file name only:

........Doc.aspx?sourcedoc=xxxxxxxxxxxx=filename.xlsx

See if this helps:

 

https://ssbipolar.com/2018/10/29/power-query-connecting-to-excel-workbooks-in-sharepoint-online/ 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@DataInsights Correct answer

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.