web
You’re offline. This is a read only version of the page.
close
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

Business Central and Power Bi integration - license

(0) ShareShare
ReportReport
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.

I have the same question (0)
  • Suggested answer
    tlhgolfer Profile Picture
    23 on at

    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!

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,111 Moderator on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,917

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,161 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,025 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans