OneDrive Dynamic Link

[acanepa]

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,

[Anonymous]

Hi @acanepa,

Power bi seems not support your method, I'd like suggest you use a static value to connect, you only need to replace the source file to get the newest data.

Regards,

Xiaoxin Sheng