Forum Discussion
CSV open from http then not refreshable by PowerbI?
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).
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 !