I have a cloud based version of BC. My previous work used on premise version. We could easily access the tables with on premise versions to get into MS Query and Power BI.
The cloud based version is not so friendly to do this. What is the best methodology of getting access to the tables through a cloud deployment?
Should we use APIs or is it something Azure services can do?
At the moment we access through Odata feeds, however these don’t get the full columns of data like the tables do…..
cheers
