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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rahulc
Regular Visitor

Sharepoint Folder or accessing excel files and combining them from document library

I have seriously combed through the forum and have used all options that were discussed.

Have new version of Power BI Desktop downloaded as well. Tried all flukes from Web etc, but Sharepoint fodler option doesn't work.
All i Get is Access to resource  is forbidden, I am the site admin.

Also my need is to load data from all the Excel file that are in Sharepoint List.
I created a folder in the list and put in all my excel file in that, hoping to combine those, But even i if i use the ODATA option I still cant get an option to combine those files.

I moved those files out and stored in teh document library without any folder, But still no luck, Any Idea how to achieve loading and combining all the excel file from a document library.

 

Thanks

7 REPLIES 7
Anonymous
Not applicable

What URL are you putting into your import?  I've had troubles in the past with SharePoint and not getting that part correct.

 

Thanks for replying.

So let say if My internal (SP13 onPremise) site is http://theta/reportdata, I have tried http://theta/reportdata and http://theta.

Unfortunately i am not an admin of http://theta.

 

I have also use the _Vti_bin url for Odata, The problem is that Result shows me the name of the files and not the content of the file,Obviously i can understand that I am Query a list data not the list with excel files in it.

 

So thats the reason I wanted to go with Sharepoint folder and combine the files.

Anonymous
Not applicable

 

In a version i've used, my power query line to get access to a file i've hosted on sharepoint looked like this:

Source = Excel.Workbook(Web.Contents("https://THETA/REPORTDATA/SUBFOLDER/SUBSUBFOLDER/FILENAME.xlsx"), null, true),

Just to be clear.  THETA as i've put here is really a Something.Somethingelse.com address.

Thanks, But how about reading multiple files and I would not want to hardcode a name of the file as the files will grow.

Anonymous
Not applicable

My intentions were to combine the file from the sharepoint folder.

So i guess i have to settle for Webdav on a shared drive.

 

Thanks

 

 

Thanks for replying.

So let say if My internal (SP13 onPremise) site is http://theta/reportdata, I have tried http://theta/reportdata and http://theta.

Unfortunately i am not an admin of http://theta.

 

I have also use the _Vti_bin url for Odata, The problem is that Result shows me the name of the files and not the content of the file,Obviously i can understand that I am Query a list data not the list with excel files in it.

 

So thats the reason I wanted to go with Sharepoint folder and combine the files.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.