Power BI integration with On-Premise Business Central

(0) Share

Report

Posted on by Afazal

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?

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.

I have the same question (0)

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.

Was this reply helpful? Yes No
Suggested answer

Afazal 135 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.

Was this reply helpful? Yes No
Afazal 135 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.

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
Afazal 135 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?

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
Afazal 135 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..

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 398 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 ?

Was this reply helpful? Yes No
Afazal 135 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...

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 398 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

Was this reply helpful? Yes No