Skip to main content

Notifications

Business Central forum
Suggested answer

Power BI Finance App Will Not Connect to Production Company

Posted on by 3,480

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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,510 Super User 2024 Season 2 on at
    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 Profile Picture
    john.ellis 3,480 on at
    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 Profile Picture
    john.ellis 3,480 on at
    RE: Power BI Finance App Will Not Connect to Production Company

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

  • john.ellis Profile Picture
    john.ellis 3,480 on at
    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 Profile Picture
    Javier.Armesto 16 User Group Leader on at
    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 Profile Picture
    YUN ZHU 69,510 Super User 2024 Season 2 on at
    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/

    pastedimage1663042397273v1.png

    And another example.

    https://yzhums.com/24811/

    pastedimage1663042564724v2.png

    Hope this helps

    Thanks.

    ZHU

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans