Forum Discussion
Business Central Web Service Filtered
Hi,
i have a web service (Customer Ledger Entry) filtered in Document Type = "Invoice", but when i connect from Power BI, whit the option Business Central connection, the data retrieved is not filtered.
6 Replies
Hi Anonymous ,
can you share some screenshots?
Hi Anonymous ,
Did you get data from your web service by desktop? Could you please tell me how did you do? Or you can filter the data in power query to work on it.
From BC, when i create the WS, i filtered de data to show only the Customer entries type INVOICE.
When i click in my Odata WS in BC, the URL is correct ($filter=Document_Type%20eq%20%27Factura%27), and i retrieve the data filtered.
But when i get the data from BI, the initial data is not filtered. I can filter after retrieve the data, but i need before.
