Forum Discussion
CSV open from http then not refreshable by PowerbI?
Dear Community,
I made an amazing dashboard yesterday and was so stunded by the possibilities offered by PBI !
This dashboard is using several sources that are CSV files, all located on the same http server.
I basically used the Get Data > Text/CSV function and copy/passed the URL of the different files, and it went perfectly well.
Unfortunately today, the dashboad won't get refreshed at all, wether on desktop nor on the cloud.
on Desktop, it seems that it'll try to get the CSV not from my http address but from a local path (which is too bad, since I provided an up-to-date accessible address).
Any advice on how to get my CSV file refresh without having to break all the work I did yesterday?
thanks !
The outcome of this issue is that indeed the "New Source->Text/CSV" option will accept https:// link but this will only copy/paste locally the remote csv file. The datasource will not be kept online. So during the next refresh, it will try to load the temporary file stored somewhere which will very quickly leads to errors (data not refresh, file not found).
The solution is simply to use the "New Source->Web" option to paste the https link to the csv file(s).
5 Replies
What Error do you get when you try to refresh?
First file says :
list[1]
Could not find file 'C:\Users\frvma\AppData\Local\Packages\Microsoft......then :listdop[1]Loading blocked by failures with other queries.Hi soussou3654 ,
Scroll down and go through the messages one by one. In (at least) one of the load, you will be able to locate an error. Then fix it and continue.It is possible that the fields in some tables have changed.
refer the following article with the same question ,and I think it is helpful for you:
Similar error refer:
Best Regards
Lucien
Hello everyone, and thanks a lot for your support.
I might have been not specific enough on my problem.
What I am facing is that I can very easily put an URL like http://mydomaine/mycsv.csv into the "Get Data->Text/CSV" prompt box, and then create my dashboard. That works perfectly well until...
However, whenever I want to refresh my dashboad in order to make a new http request to get a fresh file, PowerBI will claim that either the file does not exist, or more specificaly that the file must be a valid specific (and local) path. I tried as you suggested to go into the advanced setting of the datasource and replace the local path by a remote (http) one and will get this :
What I understand is that PowerBI just create a local copy of my file from the http I submitted and then refer to this local path as the main source. This is annoying to offer the possiblity to use a remote address in first hand and then get stuck in second hand without being able to refresh it.
So bottomline, what would you suggest to easily use an http refreshable address to get CSV files for my dashboard ?
thanks a lot !
The outcome of this issue is that indeed the "New Source->Text/CSV" option will accept https:// link but this will only copy/paste locally the remote csv file. The datasource will not be kept online. So during the next refresh, it will try to load the temporary file stored somewhere which will very quickly leads to errors (data not refresh, file not found).
The solution is simply to use the "New Source->Web" option to paste the https link to the csv file(s).
