web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Best practices for BC ...
Small and medium business | Business Central, N...
Suggested answer

Best practices for BC Power BI reports

(0) ShareShare
ReportReport
Posted on by smshyd 155

Hi Experts,

 I am working on Power BI with Business central 19.

1) Which object is recommended for  Power BI performance  whether it is a page or query,

2) what is recomended for Power BI with Business Central whether it a Standard API or advance or Web service legacy. Up to what time web service legacy is supported by Microsoft

3) What if I publish standard pages of Item ledger entry , Vendor Ledger Entry and Customer ledger entry in the power Bi does it cause any performance

 4) when Oauth authentication is needed power BI , is it only for schedule refresh , or there any other scenario where it might be needed  

5) if I want have data multiple companies in single visual does Microsoft provide any best practices

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 91,771 Super User 2025 Season 2 on at
    RE: Best practices for BC Power BI reports

    Hi, just add some info from BC Launch Event 2021 Release Wave 1.

    So Using Standard APIs and custom APIs is definitely a better choice.

    pastedimage1645404111981v1.png

    pastedimage1645404143238v2.png

    pastedimage1645404155469v3.png

    PS: The capability of exposing SOAP endpoints will be removed in a later release.

    https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/deprecated-features-platform#soap-endpoints-warning

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,656 Moderator on at
    RE: Best practices for BC Power BI reports

    Hi,

    Have a look here:

    Basically:

    • API's are faster then ODATA web services.
    • Queries can aggregate rows (group by, sum,...) and should be used for transactions.
    • Pages are cached and could be interesting for master data.
    • Don't use standard pages as web services.
    • The standard api's are really good and contain most required information.
    • Create custom api queries/pages if you need to include non-standard fields/tables.
    • Scheduled refresh can use a BC user (AAD), nothing special required for OAuth
    • Multi-company: easy, use my template
    • Performance tips: don't import what you don't need, use queries, filter your apis, and use Using Read Scale-Out for Better Performance - Business Central | Microsoft Docs 
    • If you need to be compatible with BC ON Prem, use ODATA webservices because BC On Prem does not support APIs yet for Power BI.

    Here's some learning materials:

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,515 on at
    RE: Best practices for BC Power BI reports

    Hi

    These answers are based on my research for our Power BI. Others may have a different feedback.

    1) for performance and ease of use Query is recommended. But since it is require BC development it could slow down Power BI development. In addition, every time you need a new field then in Power BI then it need BC development.

    2) Use Power Bi BC connector. See this article. businesscentral.dynamics.com/ridedesigns.com also I know MS will discontinue Web Service Key but nothing about Web Service (docs.microsoft.com/.../deprecated-features-platform)

    3) The only performance issue in BC you will have is if you pass ODATA limit. See docs.microsoft.com/.../operational-limits-online  we usually update our Power BI at dead time (about 2 am)

    4) it is for accessing data and refreshing data.

    5) See this article thinkaboutit.be/.../

    Extra considerations

    1) You can use tools like Clour Replicator to create data warehouse

    appsource.microsoft.com/.../pubid.efoqus-5058796|aid.replicator|pappid.18a4d438-88d1-44ee-a38d-3c0ea0d77338

    2) You may also can search for some idea like this to utilize Microsoft dataverse

    www.youtube.com/watch

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,666

#2
Sumit Singh Profile Picture

Sumit Singh 2,885

#3
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,293

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans