cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
acanepa
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:

 

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,

1 REPLY 1
v-shex-msft
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.

 

Regards,

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

Announcements
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!

secondImage

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.

secondImage

Experience what’s next for Power BI

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