How to get info from Posted sales shipment table table in power bi

(0) Share

Report

Posted on by KC-25070654-0

Hi everyone,

My company is using Business Central and Power BI (reporting). I would like to query the "posted sales shipment" table present in Business Central in order to filter my "sales orders" tables based on whether they got shipped or not.

At the moment I cannot see the "posted sales shipment" table from the "Get Data" tab.

Is there any reasons why I cannot access this table from Power BI using the "Dynamics 365 Business Central" query connector? Any workaround?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

keoma 32,729 on at

Like (0)

Report

use table sales shipment header.

Was this reply helpful? Yes No
divyeshchitte 968 on at

Like (1)

Report

You can search for

Sales shipment header

Sales shipment line

Was this reply helpful? Yes No
KC-25070654-0 on at

Like (1)

Report

Thanks for your answer,

However I cannot see such table in the "Navigator" when I open the "business central connector" in power bi "Get data".

Is it by default that we can see such table in power bi? Is it possible there is any "filters" on what I can see in the "Navigator" when I open the "business central connector" in power bi "Get data"?

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

add new web service entry in dynamics nav.

type=page, no.=142, servicename=PostedSalesShipment, published=true

you could also use no.=130 instead.

then try again in power bi.

if you get an error in power bi using the according odata link (odata feed in power bi), then work with

http://<server:port>/<servicename>/OData/Company('CRONUS%20AG')/

instead of

http://<server:port>/<servicename>/OData/Company('CRONUS%20AG')/PostedSalesShipment

you get then the query editor. there run "refresh preview". to get the new odata entry.

for detailled help goto:

https://community.powerbi.com/t5/Power-Query/Power-BI-desktop-gives-error-415-Unsupported-Media-Type-with/td-p/15438

Was this reply helpful? Yes No
Verified answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

Please have a look here:

thinkaboutit.be/.../

Was this reply helpful? Yes No
KC-25070654-0 on at

Like (0)

Report

Thanks :) I m currently implementing this solution

Was this reply helpful? Yes No