Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Im new with Power BI and have run in a issue.
The data that i use i get by using Web as datasource and then entering the URL.
The problem is that the URL contains a Begin and Endate. namely .CVS?from=2016-07-26&to=2016-07-27
My question is how do i replace these value automaticlaly with the the Current Date in to= And the day of Yesterday for from=
Solved! Go to Solution.
Hi Jar343,
Based on my research, you could try to use Power Query Formula Language (informally known as "M") in the Advanced Editor.
let Source = Web.Page(Web.Contents("http://www.domain.com/xxx.CVS?from=" & DateTime.ToText(Date.AddDays(DateTime.LocalNow(), -1), "yyyy-MM-dd") & "&to=" & DateTime.ToText(DateTime.LocalNow(), "yyyy-MM-dd"))), Data0 = Source{0}[Data] in Data0
Hi Jar343,
Based on my research, you could try to use Power Query Formula Language (informally known as "M") in the Advanced Editor.
let Source = Web.Page(Web.Contents("http://www.domain.com/xxx.CVS?from=" & DateTime.ToText(Date.AddDays(DateTime.LocalNow(), -1), "yyyy-MM-dd") & "&to=" & DateTime.ToText(DateTime.LocalNow(), "yyyy-MM-dd"))), Data0 = Source{0}[Data] in Data0
Hi Sam,
Thanks for your help it works quite good but because of the Power Query Foluma i have run in another issue.
With your code the data that is shown is only from today the -1 does not seem to do anithing i have also changed it to -4 with no effect.
I have tried changin your code to
from=" & DateTime.ToText(Date.AddDays(Date.From(DateTime.LocalNow()), -1), "yyyy-MM-dd") & "&to=" & DateTime.ToText(DateTime.LocalNow(), "yyyy-MM-dd"))),
in #""
But now i get the error
Expression.Error: Can not convert the value #date(2016, 8, 😎 to type DateTime. Details: Value=8/8/2016 Type=Type
Finally I also tried to do the Load from with static values but to now effect
Hi Sam,
Yoour solution worked perfectly just had to remove the space in
(Date.From(DateTime.LocalNow()), -1),
TO
(Date.From(DateTime.LocalNow()),-1),
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |