Hello All,
I have a csv file coming directly from OneDrive, where the file have the date in the name, so it generates a new file every day. The logic is very ismilar to this:
Companyname_20170221.csv
I made a calculation in PowerQuery language for capture the change in the day, taking the file from OneDrive.
The Problem is that OneDrive refresh didn´t work with this type of file in PowerBI cloud, it works well in PowerBI desktop, but I want to fully automate the process.
The PowerQuery code is like this
let
V = if Date.Month(DateTime.LocalNow()) <10 then Text.Combine({"0", Number.ToText(Date.Month(DateTime.LocalNow())),Number.ToText(Date.Day(DateTime.LocalNow()))},"") else Number.ToText(Date.Month(DateTime.LocalNow())),
Source = Csv.Document(Web.Contents("Private URL/Companyname" & V & ".csv"),[Delimiter=",", Columns=31, Encoding=1252, QuoteStyle=QuoteStyle.None])The error I get from PowerBI cloud is
| Error del origen de datos: | Unable to refresh the model (id=1708304) because it references an unsupported data source. |
There is a workaround in this subject?.
Thanks in advance.
Regards,
