Skip to main content

Notifications

Business Central forum
Answered

Power BI integration with On-Premise Business Central

Posted on by 756

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

  • Verified answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Power BI integration with On-Premise Business Central

    Hello,

    Yep, that is in our docs.

    Thanks.

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

    Now, I am getting the value in taken cache table, so the main setting was to select the "Accounts in any organizational directory (Any Azure AD directory - Multitenant)" type.

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

    I checked this through table information inside the business central, in may case it shows the 0 record.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Power BI integration with On-Premise Business Central

    Hi,

    You can check the values directly via SQL Server Management studio. If you do not want to do that, feel free to raise it via a support ticket.

    Thanks.

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

    following point not understand

    "The table Token Cache will in the event of a success get a value. If it shows a wrong E-mail address, the consent is applied to a different account and PowerBi will not work with the new account (same error as shown here)."

    how we can check this?

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Power BI integration with On-Premise Business Central

    Hello,

    The Azure AD app must be configured as a multi tenant Azure AD app. You can easily check this by looking at the bottom of the manifest file in the Azure AD app. The key is called SignInAudience. This must be of type AzureADMultipleOrgs. Anything else like AzureADMyOrg will not work. 

    The table Token Cache will in the event of a success get a value. If it shows a wrong E-mail address, the consent is applied to a different account and PowerBi will not work with the new account (same error as shown here).

    Yesterday I had the same issue which I was able to resolve (multiple accounts that I use for testing, multiple tests done, one tenant, one database).

    Thanks.

  • Afazal Profile Picture
    Afazal 756 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..

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 43 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
    Afazal 756 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
    Bilal Haider 43 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

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans