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

Creating Reports using Power BI

(0) Share

Report

Posted on by snoppy

4,824

Hi experts, a quick question on creating the reports (we have not subscribed the BC365 yet). If we use Power BI, do we need to add the code behind? What is the best and quickest way of creating customized reports?

Thank you!

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Jyotsna NAV 585 on at

Like (0)

Report

You do not have to add any Code-behind in Business Central if that is what you are asking.

But you need to do perform Configuration for you to add Power BI reports in D365BC.

Check this link: docs.microsoft.com/.../admin-powerbi

Regards
Jyotsna
jyotsnanav.blogspot.com

Don't forget to help the community by verifying the answer or at least like the suggestion if it did help in any way. It will let others know that the topic has a verified

Was this reply helpful? Yes No
snoppy 4,824 on at

Like (0)

Report

In order to create the report, which Power BI plan will suffice? Thank you!

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

It depends on what you want. The Power BI desktop is free, but only for single user. That means you can't share your Power BI with other users.

Was this reply helpful? Yes No
snoppy 4,824 on at

Like (0)

Report

After the report is created from BI, is there any way to import the report to the system? Or is the Power BI connected already with BC365 and there is not need to import? Thank you!

Was this reply helpful? Yes No
Suggested answer

Jyotsna NAV 585 on at

Like (0)

Report

Check: docs.microsoft.com/.../admin-powerbi

Regards
Jyotsna
jyotsnanav.blogspot.com

Don't forget to help the community by verifying my answer or at least like the suggestion if it did help in any way. It will let others know that the topic has a verified answer and was beneficial to you.

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

You can use Power BI Desktop to create report(s) and a Power BI subscription (Pro) to 'share' reports and dashboard. The free subscription can also be used to create dashboards, but without sharing.

You can use the PBI connector for Business Central to connect to BC and import data using the API, but imho it's much better to create good, fast, scalable, dedicated queries using the development environment, otherwise your report will become: slow and complex to maintain.

BC can embedd Power BI reports published to the default workspace.

And fyi, you can't have 'best' and 'quick' in the same sentence when it comes down to creating customized reports. Quick is possible, but that won't be fast/scalable/good. 'Best' takes time to think about and create good queries, a data model and report(s) and dashboards.

Was this reply helpful? Yes No