Forum Discussion
Data Source
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?
Sorry vanessafvg I will try to be more explicit,
1. Effectively there are lots of files in my sharepoint folder..
2. So yes I have a .xlsx for my table but I can't enter it directly, so I have to enter my link with it folder but I have the error which I show you in the second picture.. So I enter the folder before these and it work but I saw nothing.
In the other direction, when I am on my sharepoint ( I am not sure it is one) in the last folder I can enter on Power BI, I suspect having to choose the folder that contains my excel in a slicer to empty my table....