Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
VickyH
New Member

Get data from archive sales orders in business Central

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?

4 REPLIES 4
Grapefarmer
Frequent Visitor

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)

Grapefarmer_0-1720052873055.png

 

Andre-SiS
Frequent Visitor

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
Advocate I
Advocate I

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
Community Support
Community Support

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.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors