Skip to main content

Notifications

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

Power BI Finance App Will Not Connect to Production Company

(0) ShareShare
ReportReport
Posted on by 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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,036 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,482 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,482 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,482 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 74,036 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans