Hello,
I have a number of reports that use the Sales Order page (42 in our System) from Business Central. Recently, this table broke in all reports that reference it. I checked the Web Services and the Sales Order page was set up just the same as before. I tried creating a new instance to connect to but it was not showing up when I "Get Data" in PBI. I tried creating new pages and queries using other IDs and they all worked immediately. I then tried creating one using the Sales Orders page ID, verified that it was available when getting data, and then tried switching the Page ID to 42 and it disappeared.. I regularly work in Power BI and have never run into this issue before. If anyone has any ideas what may be going on, all information is welcomed and helpful.
I tried using the Standard API 2.0 "salesOrders" and though this could work, it does not contain all of the fields required for some of the reports that reference this table.
P.S. We have not had any customizations made to our Sales Orders table or page in BC recently. We do have customizations but I have been working with this table in reports since then and run into no problems.
If I can provide any additional information to help you with your answer, please let me know.
Also, if this is not the correct place for this question, let me know and I will post it in the appropriate forum. It does not appear to be an issue on Power BIs end which is why I posted here instead of the Fabric Community Forum.