OneCore Reporting (Power BI) (EN)
Standard BC reporting
Microsoft offers standard reporting according to Business Central sub-modules. On the given environment/company, it is necessary to download the application to Power BI Services and then connect to the environment via Assisted Setup -->Connect to Power BI (PowerBI Reports Setup (36951)).
The detail is described in the official documentation below:
Viewing of reports is then possible by default in BC via search or action All reports. The report then has a specific type of page, namely UserControlHost.
Area | Installed in an OCO environment | Link to the application | Official documentation |
|---|---|---|---|
Finance | YES | https://learn.microsoft.com/en-us/dynamics365/business-central/finance-powerbi-app | |
Inventory | YES |
https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-powerbi-app | |
Inventory Valuation | YES | https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-valuation-powerbi-app | |
Manufacturing | NO - no relevant data in OC | https://learn.microsoft.com/en-us/dynamics365/business-central/manufacturing-powerbi-app | |
Purchasing | YES | https://learn.microsoft.com/en-us/dynamics365/business-central/purchases-powerbi-app | |
Projects | NO - no relevant data in OC |
https://learn.microsoft.com/en-us/dynamics365/business-central/projects-powerbi-app | |
Sales | YES |
https://learn.microsoft.com/en-us/dynamics365/business-central/sales-powerbi-app | |
Subscription Billing | NO - no relevant data in OC |
| |
Sustainability | NO - no relevant data in OC |
|
All information on reporting in BC can be found here:
OneCore Reporting
Reporting in the Microsoft Dynamics 365 Business Central information system and OneCore is an important part for the management and analysis of leasing operations. Depending on the purpose and goal of reporting, different types of reports can be used. They are an important tool for visualizing and analysing portfolios, leasing contracts, customers, suppliers or the activity of their own salespeople.
Reference | |
BC/OC Environment | https://businesscentral.dynamics.com/OCO?company=CRONUS%20CZ&dc=0 |
Power BI Service - update | automatically, daily at 6:00 a.m. (according to settings) |
Reporting language | ENG |
Power BI documentation
Microsoft Power BI is a business intelligence tool that enables you to visualize data and share insights across your organization. Users can easily connect various data sources, create interactive reports and dashboards, and analyze key performance indicators (KPIs) in real-time. Power BI supports advanced analytics, such as predictive models and DAX for calculations, and is tightly integrated with other Microsoft products such as Excel, Azure, and Teams. It is suitable for both analysts and ordinary users without deeper technical knowledge.
The general documentation of the standard product is described at the link below.
Power BI licenses
Viewing reports in Power BI Service is dependent on a valid license.
Power BI Free
Power BI Pro
Power BI Premium Per User (PPU)
Power BI Premium (Per Capacity) (phasing out)
Microsoft Fabric Capacity (new model)
Power BI Embedded - is a Service from Microsoft that allows developers to integrate interactive Power BI reports and dashboards directly into their own web or mobile applications. It is designed primarily for software companies or developers who want to offer their customers data visualization without the need to have their own Power BI account.
The individual versions of the license, including prices, are described below.