oData URL filter for last 30 days (today less 30)

[mbarbera83]

Hi Everyone.

Is it possible to filter in the source URL based on a column of document date:

something like - = OData.Feed("https://xxxxx.co.za/OData/ODatav4/Company('XXXX')/View?$filter = Posting date gt (now()-30)

I want to limit the time it takes to refresh my data, but saying just give me the last 30 days.

can anyone help?

[Anonymous]

@mbarbera83 
I doubt you can filter the Source URL before importing to power bi. 
Solved: OData filter pass-through - Microsoft Power BI Community

For your requirement, I would suggestion you to use incremental refresh to set the refresh range to last 30 days.

Incremental refresh for datasets in Power BI - Power BI | Microsoft Docs

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[mbarbera83]

Hi Pat. Thanks for the quick response.

I tried that but received : Expression.SyntaxError: Token Comma expected.

I have attached below my code - am I missing something?

= OData.Feed("https://XXXX.co.za:/ODatav4/Company/ValueEntriesPage?$filter=Posting_Date gt " & Date.ToText(Date.AddDays(Date.From(DateTime.LocalNow()),-65), "yyyy-MM-dd")") , null, [Implementation="2.0"])

[mahoneypat · Accepted solution]

Since the Date.ToText returns text, you don't need to wrap it in ".  Please try this instead.

= OData.Feed("https://XXXX.co.za:/ODatav4/Company/ValueEntriesPage?$filter=Posting_Date gt " & Date.ToText(Date.AddDays(Date.From(DateTime.LocalNow()),-65), "yyyy-MM-dd") , null, [Implementation="2.0"])

Pat

[mahoneypat]

You can use this expression.  Adapt the date format if you need something different.

 OData.Feed("https://xxxxx.co.za/OData/ODatav4/Company('XXXX')/View?$filter= Posting date gt " & Date.ToText(Date.AddDays(Date.From(DateTime.LocalNow()), -30), "yyyy-MM-dd")")

Pat