# Connect to Power BI from Business Central on-premises
## Prepare for Power BI integration
Enable Business Central on-premises for Power BI integration. An administrator typically completes this task. See Set up Business Central for Power BI integration<admin-powerbi-setup>.
Some features are only available with Business Central online, not on-premises. See Introduction to Business Central and Power BI<admin-powerbi#get-ready-to-use-power-bi>
## Set up Business Central on-premises for Power BI integration
This section explains the requirements for a Business Central on-premises deployment to integrate with Power BI.
1. Configure either dev-itpro/administration/authenticating-users-with-navuserpassword or Microsoft Entra ID<dev-itpro/administration/authenticating-users-with-azure-ad-overview> as the authentication method for the deployment.
> NOTE
> Power BI integration doesn't support Windows authentication.
1. Enable OData web services and the ODataV4 endpoint.
 Enable OData web service on the Business Central Server and open the OData port in the firewall. See Configuring Business Central Server - OData Web Services<dev-itpro/administration/configure-server-instance#ODataServices>.
 The local server must be accessible from the Internet.
1. Give Business Central user accounts a web service access key.
 A web service access key is only needed to view Business Central data in Power BI. You can assign a web service access key to each user account. Or instead, create a specific account with a web service access key for use by all users. See dev-itpro/webservices/web-services-authentication#generate-a-web-service-access-key.
1. Create an application registration for Business Central in Microsoft Azure.
 To view Power BI reports embedded in Business Central pages, register an application for Business Central in Microsoft Entra ID. The registered application needs permission to Power BI services. At a minimum, the app requires User.ReadWrite.All permission. For users to view reports from shared Power BI workspaces, the app requires Workspace.Read.All permission. See Registering Business Central on-premises in Microsoft Entra ID for Integrating with Other Services<dev-itpro/administration/register-app-azure>.
> NOTE
> If your deployment uses NavUserPassword authentication, Business Central connects to the same Power BI service for all users. You specify this service account as part of registering the application. With Microsoft Entra authentication, Business Central connects to the Power BI service associated with the individual user accounts.
1. Make the initial connection from Business Central to Power BI.
 Before users can use Power BI in Business Central, an Azure application administrator must give consent to the Power BI service.
 To make the initial connection, open Business Central, and run Get Started with Power BI from the Home page. This action leads you through the consent process and checks your Power BI license. When you're prompted, sign in using a Microsoft Entra admin account. See Connect to Power BI - one time only<across-working-with-powerbi#connect>.
## Build Power BI reports displaying Dynamics 365 Business Central data
You can make your Dynamics 365 Business Central data available as a data source in Power BI Desktop and build powerful reports of the state of your business.
Use Power BI Desktop to create reports that display Dynamics 365 Business Central data. After creating reports, you can publish them to your Power BI service or share them with all users in your organization. Once these reports are in the Power BI service, users set up for it can view the reports in Business Central.
 For Business Central on-premises, get the following information:
   The OData URL for Business Central.
    Typically, this URL has the format `http[s]://[computer]:[port]/[serverinstance]/ODataV4`, for example, `https://localhost:7048/BC190/ODataV4`. If you have a multitenant deployment, include the tenant in the URL, for example, `https://localhost:7048/BC190/ODataV4?tenant=tenant1`.
   A user name and web service access key of a Business Central account.
    To get data from Business Central, Power BI uses basic authentication. So, you need a user name and web service access key to connect. The account might be your own user account, or your organization might have specific account for this purpose.
## Add Business Central as a data source in Power BI Desktop
The first task in creating reports is to add Business Central as a data source in Power BI Desktop. Once connected, you can start to build the report.
1. Start Power BI Desktop.
1. Select Get Data.
 If you don't see Get Data, select the File menu, then Get Data.
1. On the Get Data page, select Online Services.
1. In the Online Services pane, connect to Business Central on-premises, select Dynamics 365 Business Central (on-premises), then Connect.
1. Sign in to Business Central (one-time only).
 If you're not signed in to Business Central from Power BI desktop before, you're prompted to sign in.
 For Business Central on-premises, enter the OData URL for Business Central and select OK. When prompted, enter the user name and password for the account for connecting to Business Central. In the Password box, enter the web service access key. Select Connect when done.
> NOTE
> After you connect to Business Central, you aren't prompted again to sign in. How do I change or clear the account I'm currently using to connect to Business Central from Power BI Desktop?<power-bi-faq?tabs=designer#perms>
1. Once connected, Power BI contacts the Business Central service. The Navigator windows appears and displays available data sources for building reports. Select a folder to expand it and see the available data sources.
 The on-premises connector lists published OData web services, such as pages and queries, grouped by company.
> NOTE
> The Dynamics 365 Business Central (on-premises) connector doesn't support API endpoints. Business Central on-premises itself supports APIs, which an administrator can enable separately.
1. Select the data source or sources that you want to add to your data model, and then select the Load button.
1. To add more Business Central data later, repeat the previous steps.
Once the data is loaded, view it in the right navigation on the page. At this point, you're successfully connected to your Business Central data and can begin building your Power BI report.
> TIP
> Learn more about Power BI Desktop in Get started with Power BI Desktop<https://learn.microsoft.com/power-bi/fundamentals/desktop-getting-started>.
## Manage and modify Power BI reports
> NOTE
> Report upload and automatic deployment from within Business Central are available only online. For on-premises deployments, manage reports in the Power BI service and modify them in Power BI Desktop.
## Upload reports to Power BI
For Business Central on-premises, no demo reports are available, so you need to start from scratch by using Power BI Desktop. Alternatively, distribute Power BI reports as .pbix files that you upload to the Power BI service. See Publish semantic models and reports from Power BI Desktop<https://learn.microsoft.com/power-bi/create-reports/desktop-upload-desktop-files>.
## Related information
Business Central and Power BI<admin-powerbi>
#upload-reports
Find free e-learning modules for Business Central here<https://learn.microsoft.com/training/dynamics365/business-central>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/across-working-with-business-central-in-powerbi, MicrosoftDocs/dynamics365smb-docs at 46907ac (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/across-working-with-business-central-in-powerbi/
