Forum Discussion

DavidB023's avatar
DavidB023
Helper III
8 years ago

Data Source

Hi Everybody !   I need to import data from an Excel file (.aspx) from a kind of sharepoint called  by "http://sps/AAA/DD/EEE/EEE/RRR.aspx"   Could anybody know how I can do that please ?   I t...
Need Help
vanessafvg's avatar
vanessafvg
Community Champion
8 years ago

DavidB023 yes because if you pointing to a sharepoint folder it then takes you to the folder, once you load up the folder information into power query you should be able to see the files there, however i am unsure around aspx.files 

 

so when you point to the sharepoint folder what do you see in there when you load it into power query aka query editor?

DavidB023's avatar
DavidB023
Helper III
8 years ago

So here is some capture of my way in order to explain you precisely my problem.

 

So I choose Sharepoint File on open source and I enter http://sps/AAAA/EEE/RRR

 

 

 

 

 

 

 

When I try with .aspx file it gave me this error :

 

I hope it could work because I really need this source ...

Thanks for your time