I am trying to make some PowerBI reports on our sales order lines.
To do that I am using webservices (ODATA v4).
I thought it would be as easy as putting in the table ID, and then publishing that able as a web service. But you cannot choose tables, you can only choose something called "objects": Each object has an ID, but it does not correspond to the table IDs.
How do I find the specific table among all the objects? The table I want is table 37, sales lines. There are some objects called "sales lines" or just "lines", and some of them have some of the data I need, but all of them is missing some specific columns.