The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
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)
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?
Hi @VickyH , did you end up finding the archived purchase orders from Business Central in Power BI? I'm facing the same problem.
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.