Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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/xxxxxx...?$filter=Posting_Date gt 2022-01-01
It currently filters by Posting_Date gt 2022-01-01
I would like to add further filter --- G_L_Account_No in 101010 101020 101030 (these are text not numbers)
Ending up with something like ?$filter=Posting_Date gt 2022-01-01 gt 2022-01-01 and G_L_Acconut_No in (101010, 101020, 101030)
What is the correct term to use please?
Thank you
Pete
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.