Need to Pass dynamic date as parameters to Web URL.

[Srividyak]

Hello Community,

If we are fetching the report in between a month we need to get the report data up to previous month last date.

Example: if we are trying to get report data at Feb 10th, we need get the report data upto january 31.

Effective date we need to pass it as dynamic.
https://xxxxxxxxxxxx.com/ccx/service/&Effective_as_of_Date=2022-01-12-&format=csv.

Your help is appreciated.

[v-jingzhang]

Hi @Srividyak 

Do you fetch data from a web service with the URL? If so, you could open Power Query Editor, select this query and open its Advanced Editor. Find your static URL string and replace the static date "2022-01-12" with &DateTime.ToText(Date.AddDays(Date.StartOfMonth(DateTime.LocalNow()),-1),"yyyy-MM-dd")&

Below is an example:

Web.Contents("https://xxxxxxxxxxxx.com/ccx/service/&Effective_as_of_Date="&DateTime.ToText(Date.AddDays(Date.StartOfMonth(DateTime.LocalNow()),-1),"yyyy-MM-dd")&"-&format=csv")

Here are documentations for Date and DateTime functions in Power Query.

Date functions - PowerQuery M | Microsoft Docs

DateTime functions - PowerQuery M | Microsoft Docs

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[freginier]

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters