Dear BC/NAV experts.
I understand that to get data from BC Online you need to grab it from a Webservice (understandable - I'm used to this in Dynamics 365 for Sales).
But here's some fundamental problems that I hope some BC expert inhere can answer - I'll use an example to address the problems:
PROBLEM 1 - access to the right fields - why can't I see all fields easily???
- I would like to make reports on the Posted Sales Invoice table (112) and have created a Webservice on page 143
- It's possible to view the table 112 in a browser using this URL: https://businesscentral.dynamics.com/?table=112 (you need run table rights)
BUT:
- Question1: Is it true that you cannot connect Power BI to the ...?table=112 page so you can get the fields you need??
- Question2: If I connect Power BI using the posted web service I miss important fields in the data set (i.e. sell-to-customer number / bill-to-customer number / exchange rate / amount) - why don't I see these fields when I use the opened web service?
PROBLEM 3 - performance problem since you cannot choose which fields to fetch in the Source Query in Power BI???
- Question3: when getting data from the webservice it retrieves ALL columns always - isn't it possible to choose which columns to retrieve?
Hope someone can help me - for if the stuff above is true you will need both a Business Central and a Power BI consultant to make proper Power BI reporting from Business Central Online - and you will never be able to make smart standard packages in Power BI, if we need to activate a webservice (where you randomly choose a name for it)
PLEASE point me in the right direction, since I'm building nice new reports for a customer who just switched from E-conomic (a Dansih ERP platform) to BC Online
/Henrik (WIKAP.DK)
