Showing results for 
Search instead for 
Did you mean: 
Resolver I
Resolver I

OneDrive Dynamic Link

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:




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


 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.



Community Support
Community Support

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.



Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.


Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.