Power BI integration with On-Premise Business Central

(0) Share

Report

Posted on by Afazal

764

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?

I have done following tasks:

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

I have a registered App in Azure active directory

I have a Power BI account and reports published.

I have a following licenses in Azure active directory.

All responses (16)

Answers (1)

Verified answer

Marco Mels on at

Like (0)

Report

RE: Power BI integration with On-Premise Business Central

Hello,

Yep, that is in our docs.

Thanks.
Suggested answer

Afazal 764 on at

Like (0)

Report

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 764 on at

Like (0)

Report

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 on at

Like (0)

Report

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 764 on at

Like (0)

Report

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 on at

Like (0)

Report

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 764 on at

Like (0)

Report

RE: Power BI integration with On-Premise Business Central

yes, below are the permissions given.

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

Bilal Haider 45 on at

Like (0)

Report

RE: Power BI integration with On-Premise Business Central

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

Also which authentication you are using for your user ?
Afazal 764 on at

Like (0)

Report

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 45 on at

Like (2)

Report

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