Forum Discussion
Solved
OData URL filter based on current Date.
In the advance editor I had this query: let FechaInicioStr = "2023-07-27", Source = OData.Feed("https://xxxx.crm.dynamics.com/api/data/v9.0/audits?$filter=createdon gt " & FechaInicioStr & " a...
The solution in the link was with a merge, but with a Query inside OData.Feed works correctly, here's is the solution
Please see this article for how to avoid that error - OData.Feed And The Dynamic Data Sources Error In Power BI (crossjoin.co.uk).
Also, you could switch to Web.Contents and use the RelativePath option (links about that in that article too).
Pat