Hi:
I downloaded and installed Power BI's Finance app for Business Central.
It shows data from the Cronus sample company but refuses to connect to the production company.
Granted, the production company has no transactional data in it. But, I would think that I would receive more than a message simply saying that the refresh failed.
What did I do wrong?
Thanks!
John
It is possible, so I think you can try to create a demo environment first. Then make sure there is no problem with Power BI.
Hope this helps as well.
Thanks.
ZHU
I do wonder if this has anything to do with transactions not being in the company, yet.
Below are the details of the error message.
It mentions the following: The Acc. Sched. KPI Buffer table is empty.
So, this is dependent upon either having data in the company or having an active Account Schedule in place.
Any other ideas?
Thanks!
John
Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Dynamics365BusinessCentral: Request failed: The remote server returned an error: (400) Bad Request.
(The Acc. Sched. KPI Buffer table is empty. CorrelationId: fd363705-ae39-4d4c-9457-7ffd42c30b9e.)"}}],"exceptionCulprit":1}}} Table: powerbifinance.
I had already tried this. But, I get that error.
Hi Zhu:
I had already tried this. But, I get that error.
John
You should tap on the message that appears when you open the Power BI app:Connect to your data. Located at the top of the app.
If you found the answer useful, mark it as verified. It will help the rest of the users with the same problem
Hi, There should be a button below, click it to connect to your database.
More details: https://yzhums.com/4637/
And another example.
Hope this helps
Thanks.
ZHU
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,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148