Get data from archive sales orders in business Central

[VickyH]

I am trying to connect the table archive sales orders in business Central in cloud to Power BI, but can't find the it from the list.

Did anybody try?

[Grapefarmer]

Hi;

D365 BC Doesn't have connections to archive sales orders set up by default, but you can expose custom endpoints in web services that Power BI can hook into. 

You'll need to expose endpoints for page object ID's 80114, 6619, 5159 and 1530; depending on how much detail you need from these documents. (see screenshot)

[Andre-SiS]

I am also looking for a way to connect Power BI to Archived Sales Orders. 

@v-angzheng-msft  Have you found any solution to this? 

[cARLOSPERALTA]

Hi @VickyH , did you end up finding the archived purchase orders from Business Central in Power BI? I'm facing the same problem.

[v-angzheng-msft]

Hi, @VickyH 

Not clear enough for me to understand what exactly you want to acheive.

Could you please consider sharing more details about it? It would be better if there are some screenshots here.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.