Skip to main content

Notifications

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

Default Power BI Apps -- Sales Works But Finance Does Not

(0) ShareShare
ReportReport
Posted on by 3,482

Hi:

The Sales app loaded and refreshed successfully for the live company in the production instance.

The Finance app loaded for the live company in the production instance but would not refresh.  Why is that?

Thanks!

John

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: Default Power BI Apps -- Sales Works But Finance Does Not

    In Acc Scheduled Name select the account scheduled that match your company account schedule for each category (balance sheet, income statement, etc) then select your budget, determine your view date (week, etc) then refresh the data (or publish then refresh) . Then go to Account Schedule Web Service and see the published data. Do you see any numbers there? 

    After that your Power BI should work (refresh the Power BI first). 

  • john.ellis Profile Picture
    john.ellis 3,482 on at
    RE: Default Power BI Apps -- Sales Works But Finance Does Not

    What exactly do you do in the Account Schedule KPI Web Service Setup window?  I'm confused.

    John

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: Default Power BI Apps -- Sales Works But Finance Does Not

    Hi John 

    I also have this issue. I realized Finance App uses data in "Account Schedule KPI Web Service" page from BC. Check that page and you can see similar data. Then you need to go to "Account Schedule KPI Web Service Setup" and put the correct setup in place in order for this app to work. I stopped there because I realized the app does not provide a data we need. 

    I am currently investigate the below app 

    appsource.microsoft.com/.../fenwicksoftware.powerbi-gold-finance

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