web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

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

Power BI integration with On-Premise Business Central

(0) ShareShare
ReportReport
Posted on by 135

I getting following error "You do not have a Power BI account. You can get a Power BI account at the following location. If you..."  while 'Authorize Azure Services' on 'Get started with Power BI' link: How to resolve this issue?

pastedimage1606209106222v1.png

I have done following tasks:

  • I have completed the 'Set Up Azure Active Directory' task in assisted setup successfully.

pastedimage1606209580518v3.png

  • I have a registered App in Azure active directory

pastedimage1606209782688v5.png

  • I have a Power BI account and reports published.

pastedimage1606209684555v4.png

  • I have a following licenses in Azure active directory.

pastedimage1606209441121v2.png

I have the same question (0)
  • Suggested answer
    Bilal Haider Profile Picture
    408 on at
    RE: Power BI integration with On-Premise Business Central

    Hi Afzaal,

    The list of licenses you have shown does not have Business Central license. Are you trying to access Business Central with a different account ? Or are you facing this issue in CE and not in Business Central ?

  • Afazal Profile Picture
    135 on at
    RE: Power BI integration with On-Premise Business Central

    I have a same account used for BC and power BI.

    I doesn't understand what is mean to CE.

  • Afazal Profile Picture
    135 on at
    RE: Power BI integration with On-Premise Business Central

    So which license I need to have..

  • Bilal Haider Profile Picture
    408 on at
    RE: Power BI integration with On-Premise Business Central

    CE means customer engagement.

    If its the same account then why Business Central license is not in list of licenses that you have uploaded.

  • Afazal Profile Picture
    135 on at
    RE: Power BI integration with On-Premise Business Central

    I have a customer engagement license as mentioned above. I am trying to integrate on premise BC not a cloud version.

  • Bilal Haider Profile Picture
    408 on at
    RE: Power BI integration with On-Premise Business Central

    You have not mentioned and I do not ask that makes confusion. I assumed its cloud version.

  • Suggested answer
    Bilal Haider Profile Picture
    408 on at
    RE: Power BI integration with On-Premise Business Central

    In Online version Business Central is all set for power BI but for On-Prem you need to make it ready

    Check these points:

    - ODATA V4 services enabled

    - Business Central user accounts have web service access key

    - NavUserPassword or Azure Active Directory Authentication is configured

    - To view Power BI reports embedded in Business Central pages, an application must be registered for Business Central in Microsoft Azure

    May be you gone through already: docs.microsoft.com/.../admin-powerbi-setup

    BC-On-prem.PNG

  • Afazal Profile Picture
    135 on at
    RE: Power BI integration with On-Premise Business Central

    Yes, I done all these steps mentioned above but no success, same error message coming...

  • Suggested answer
    Bilal Haider Profile Picture
    408 on at
    RE: Power BI integration with On-Premise Business Central

    Have you given the registered application permission to Power BI services ?  Check it please.

    1882.Permissions.PNG

    Also which authentication you are using for your user ?

  • Afazal Profile Picture
    135 on at
    RE: Power BI integration with On-Premise Business Central

    yes, below are the permissions given.

    0525.Capture.PNG

    which authentication  to your means? i don't understand..

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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

#1
Sumit Singh Profile Picture

Sumit Singh 2,179

#2
OussamaSabbouh Profile Picture

OussamaSabbouh 1,999

#3
YUN ZHU Profile Picture

YUN ZHU 1,892 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans