New Power BI Apps for Business Central: Free, Seamless, and Ready for Action!

This session focused on the integration of Power BI reports with Microsoft Dynamics 365 Business Central. Here’s a summary of the key topics and insights:

Key Topics Discussed:

1. Power BI Integration with Business Central:
   • Microsoft introduced free Power BI apps for Business Central, available in the release wave 2 of 2024. These apps include 75 pre-built reports covering various modules like finance, sales, inventory, manufacturing, etc.
   • These reports are natively connected to Business Central and offer users insights into daily business operations, helping decision-makers like CEOs or CFOs get an overview of key metrics such as top vendors, customers, turnover, and profit margin.
2. Customizing Power BI Reports:
   • Users can adjust certain settings in Power BI reports, such as date ranges and account categories (e.g., balance sheet vs. income statement accounts). However, editing the report itself (e.g., modifying visualizations or layout) is not possible directly within Business Central. For advanced customizations, users can use Power BI as a standalone tool.
3. Power BI Pro License:
   • Only one Power BI Pro license is required for setup. This license allows administrators to configure the integration and manage data connectivity. Once the setup is complete, users with Business Central licenses can access Power BI reports embedded within Business Central without needing separate Power BI licenses.
4. Setting Up Power BI in Business Central:
   • The setup process is simple with a new assisted setup guide in Business Central. After installing the necessary Power BI apps, users need to link the app to the correct Business Central environment. Additionally, users can choose to configure the refresh schedule (daily or weekly) to ensure reports are up to date.
   • It’s recommended to avoid refreshing reports too frequently (e.g., every 10 minutes) to avoid overloading the system. Instead, refreshing reports every hour or two might be more appropriate depending on data volume.
5. Multi-Company Setup:
   • If a Business Central environment includes multiple companies, each company requires its own Power BI workspace and the app must be installed for each workspace. However, users can configure a consolidation company for certain reporting purposes.
6. Viewing and Interacting with Reports:
   • Once the reports are configured, users can access them within Business Central. They can also bookmark reports for quick access and apply filters to drill down into specific data points.
7. Account Categories and Chart of Accounts:
   • Users can categorize their chart of accounts in Business Central, linking specific accounts to categories like balance sheet or income statement. This categorization will be reflected in the Power BI reports. If changes are made to the categories, users will need to refresh the Power BI reports to see the updates.

Next Steps:

• Users can follow the provided link to a step-by-step guide to set up and configure Power BI integration with Business Central. This guide allows users to replicate the steps demonstrated in the session.