Forum Discussion
PBE
3 years agoHelper II
Odata url ?$Filter for multiple filters
Hi I am using odata url link from MS Business Central to Power query/ BI using the format https://api.businesscentral.dynamics.com/vzzzzzzzzzzzzzzzz8-e2ffffffffff6/xxxxxxxxxxx/ODataV4/xxxxxxxxxxxx/...
v-yalanwu-msft
3 years agoCommunity Support
Hi, PBE ;
You could try it.
https://api.businesscentral.dynamics.com/vzzzzzzzzzzzzzzzz8-e2ffffffffff6/xxxxxxxxxxx/ODataV4/xxxxxx...?$filter=Posting_Date gt 2022-01-01 and G_LAccount_No in('101010','101020','101030')
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
Filtering OData Feeds - That NAV Guy
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PBE
3 years agoHelper II
Thanks for your reply. The code didn't work but the links look good and I'll see if I can work it out from them.
PBE