Skip to main content

Notifications

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

Business Central and Power Bi integration - license

Posted on by 5

Hi Everyone,

We discovered that there are connectors in Power BI to connect with Business Central. We hope to use our SoftwareService account to create a connection to create Power BI reports using Business Central data.

My questions are:

  • Does our SoftwareService account need a Microsoft Dynamics 365 Business Central Premium (we are hoping to utilize Service Order Management and Manufacturing capabilities) license for the connection?
  • What type of Power Bi license do I need for the SoftwareService account (since we are creating and sharing reports with this account)
  • Once we create reports in Power Bi, can users with NO license to  Business Central view/use those Power BI reports?

Thank you in advance for the advice.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Business Central and Power Bi integration - license

    Just to add to what Tanya answered you. You are mentioning a software service account. And if you are running BC online it is named users that will be able to access the Power BI data through the BC connector for Power BI.

    If you run BC on prem then you need a data connector installed on prem to access your BC data in Power BI.

  • Suggested answer
    tlhgolfer Profile Picture
    tlhgolfer 761 on at
    RE: Business Central and Power Bi integration - license

    Here are some answers to your questions:

    • Does our SoftwareService account need a Microsoft Dynamics 365 Business Central Premium (we are hoping to utilize Service Order Management and Manufacturing capabilities) license for the connection?

    You may be able to use a Teams License I have been able to access the data, but you may need a full license.

    • What type of Power Bi license do I need for the SoftwareService account (since we are creating and sharing reports with this account)

    You will need at least a pro license to share reports on the service depending on the data size of the models.

    • Once we create reports in Power Bi, can users with NO license to  Business Central view/use those Power BI reports?

    They can view the reports they just cannot refresh the data only the user that is scheduled to refresh the report needs access to the data..

    Hope this helps!

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans