Forum Discussion
Data Source
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?
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
DavidB023 well when you point to sharepoint you asking for a folder so you cant' specify a file, so is that the only file in that sharepoint folder? what are you wanting to do with the that file? aspx is not data but code?
vanessafvg Effectively, there are many files in my file but I want one specific..
I need to import the excel in order to exploit one data table on my Power BI Desktop. Also, I want after that create an actualization of my visuel in the same time of the actualization of my table .aspx with a Gataway. But if I can't open it just on my Desktop, it seems complicated.
Its a kind of table that people come enter data every months but data is "online"
DavidB023 ok sorry youve lost me
1) in your sharepoint folder are there other files?
2) power bi expects a data format as far i know so i am not sure about an aspx file, cant you just pull the excel file in directly? what is the value of the aspx? what do you need it for?