Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

How to configure a connection between Power BI and Business Central On-Premises?

(0) ShareShare
ReportReport
Posted on by 785

Hi Helping Developers,

I am trying to connect Power BI Desktop with Business Central On-premise. But not able to configure or connect as only Basic Auth is available for connection anyone can please confirm what should I do to configure the connection between BC on-premise and Power BI.

Please see the below screenshot for more understanding:

PowerBI-issue.png

Anyone, please share steps or details to configure the connection between Power BI and Business Central On-Premises.
This is very urgent please help. 

  • Suggested answer
    THE Italian Profile Picture
    on at
    RE: How to configure a connection between Power BI and Business Central On-Premises?

    docs.microsoft.com/.../admin-powerbi-setup

  • Community Member Profile Picture
    on at
    RE: How to configure a connection between Power BI and Business Central On-Premises?

    1.Select Get Data at the bottom of the left navigation pane.

    You may also get starting from within Dynamics 365 Business Edition. From the role center, navigate to Report Selection in the Power BI Role Center part. Select either Service or My Organization from the ribbon. When either of these actions are selected, you will be taken to either the Organization gallery in Power BI or to the services library in Power BI, which will also be filtered to only display content packs related to Dynamics 365 Business Central .

    1.In the Services box, select Get. This will open a page with the AppSource and Apps for Power BI apps.

    2.Select Apps from the Apps for Power BI apps tab, choose the Microsoft Dynamics 365 Business Central content pack that you want to use, and then select Get it now.

    3.When prompted, enter the name of your company in Dynamics 365 Business Central . This is not the display name. The company name can be found on the 'Companies' page within your Dynamics 365 Business Central instance.

    4.Once connected, a dashboard, report and dataset will automatically be loaded into your Power BI workspace. When completed, the tiles will update with data from your Dynamics 365 Business Central company.

    Hope this helps you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,748 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans