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

[rahulc]

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

[Anonymous]

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

[rahulc]

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.

[rahulc]

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]

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.

[rahulc]

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]

Perhaps this thread might be of interest

http://community.powerbi.com/t5/Desktop/dynamically-import-files-from-a-folder-WITHOUT-combining-the...

[rahulc]

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

[rahulc]

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.