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

Best practices for BC Power BI reports

(0) Share

Report

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)

All responses (3)

Answers (0)

Suggested answer

MahGah 15,593 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,686 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi,

Have a look here:

thinkaboutit.be/.../

thinkaboutit.be/.../

thinkaboutit.be/.../

thinkaboutit.be/.../

thinkaboutit.be/.../

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:

Use Power BI in Microsoft Dynamics 365 Business Central - Learn | Microsoft Docs

Webinar Mastering Advanced Power BI for Business Central | Plataan.TV

Business Central Power BI Training - Business Central Booster

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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.

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

Was this reply helpful? Yes No