I've been attempting to connect my instance of Business Central and PowerBI.com via Power BI's "Microsoft Dynamics 365 Business Central – Finance" app, but I keep receiving the below error.
MessageDynamics365BusinessCentral: Request failed (404): The remote server returned an error: (404) Not Found. (The Acc. Sched. KPI Web Srv. Setup does not exist. Identification fields and values: Primary Key='') Table: powerbifinance.
I've successfully connected using the "Microsoft Dynamics 365 Business Central – CRM" app without issues, and a few other Microsoft Dynamics 365 Business Central apps.
Is there something extra that needs to be set up in business central to connect with the finance app?
H
Thanks! I will perform additional testing in Cronus and start a new thread if I am unable to move forward.
Hello,
Can you try the same scenario in the demo CRONUS company where data is populated and can be shown in reports. It is probably best to start a new forum posting on this for the visibility and help of others.
Thanks.
I figured out how to add the new account schedules to the web service. My next issue is that I am getting data for only one financial report: Total Revenue. All other reports, including the Mini Trial Balance have no data. Can you help me with this? Thanks!
The Web Service is published. However, it was published prior to setting up all of the account schedules. It appears that the web service needs to be republished, as only the KPIs that were in existence prior to publishing are showing up. How do I republish?
Hello,
Can you search for KPI in your Business Central and select Account Schedule KPI Web Service Setup and note what you see. Published should be set to "Yes". If it not set to Yes, you can click on "Public Web Service". In your search results, there are two others. Maybe you can verify these as well.
Thank you.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,782 Super User 2024 Season 2
Martin Dráb 229,067 Most Valuable Professional
nmaenpaa 101,150