Small and medium business | Business Central, N...

Power BI Finance App Will Not Connect to Production Company

(0) Share

Report

Posted on by john.ellis

3,500

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

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 92,886 Super User 2025 Season 2 on at

Like (0)

Report

RE: Power BI Finance App Will Not Connect to Production Company

Hi, There should be a button below, click it to connect to your database.

More details: https://yzhums.com/4637/

And another example.

https://yzhums.com/24811/

Hope this helps

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Javier.Armesto 14 User Group Leader on at

Like (0)

Report

RE: Power BI Finance App Will Not Connect to Production Company

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

Was this reply helpful? Yes No
john.ellis 3,500 on at

Like (0)

Report

RE: Power BI Finance App Will Not Connect to Production Company

Hi Zhu:

I had already tried this. But, I get that error.

John

Was this reply helpful? Yes No
john.ellis 3,500 on at

Like (0)

Report

RE: Power BI Finance App Will Not Connect to Production Company

I had already tried this. But, I get that error.

Was this reply helpful? Yes No
john.ellis 3,500 on at

Like (0)

Report

RE: Power BI Finance App Will Not Connect to Production Company

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,886 Super User 2025 Season 2 on at

Like (0)

Report

RE: Power BI Finance App Will Not Connect to Production Company

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

Was this reply helpful? Yes No