In Business Central Web services, I am attempting to publish Object ID 112 Sales Invoice Header and then pull the data into Power BI. I feel that I am missing some fundamental understanding of how to approach the Web Services part; I can retrieve other published data in Power BI. My attempts have included (with images):
1. Create a new web service by searching on the ID, provide a Service Name (Sales_Invoice_Header) and then select Publish.
2. After doing so, the Object Name changes to Inventory Posting Groups and a search also now shows 112 Inventory Posting Groups.
3. In Power BI, I can see the Service Name (Sales_Invoice_Header), and am also shown that This table is empty.
4. To further investigate, I open the Jet Reports Browser and find the Sales Invoice Header table (number 112).
5. I can drop that into Excel and retrieve the entire data set.
6. If I attempt to change the Object Type from Page to Query in Web services, it cannot find the object.
The expectation is to be able to publish the Web Service Object ID 112 Sales Invoice Header and then pull the data into Power BI.
Any insight into what I may be missing in this approach?
