Hello Everyone!
I would like to pull in Power BI some tables, that are not available by default in a list generated by Get Data->Dynamics 365 Business Central->MyCompany. So I've learned the way of using Web Services in Dynamics to publish a page that I need. However Pages might not contain all details that I want and by using "Inspect page" functionality I can get the required number of a Table that contains all columns.
The problem is that in "Web Service" there is no object type called "Table" (I see only Codeunit, Page, Query) so when I select any of them and indicate the desired Table number in ID field I get an object of another type (Codeunit, Page, Query) that has the same ID as a Table that I want to pull to PowerBI.
Any ideas how to pull to PowerBI the whole table by kwing its ID? Would be grateful if solution woudn't require creation of queries but could use only standard Dynamics functionality.
Thank you!
