Forum Discussion
oData URL filter for last 30 days (today less 30)
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
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.