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,482

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

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 74,036 Super User 2024 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
john.ellis 3,482 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.
john.ellis 3,482 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.
john.ellis 3,482 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
Suggested answer

Javier.Armesto 16 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
Suggested answer

YUN ZHU 74,036 Super User 2024 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