Business Central on Premise Power BI Integration

(0) Share

Report

Posted on by Bilal Fazrin

Hello All,

I currently new at doing BC integration.
I'd like to show published power BI report to Business Central On-Premise.
But Im having a trouble when trying to do the setup

I have followed the guide from microsoft :
- https://learn.microsoft.com/en-us/dynamics365/business-central/admin-powerbi-setup
- https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/register-app-azure
- https://learn.microsoft.com/en-us/azure/active-directory/develop/quickstart-register-app#add-a-client-secret

I am currently stuck when trying to Authorize Azure Services

I've seen some post with the same issue, but the creator doesn't seem to conclude whether they already solved it or not.
So i haven't found any solution until now.
Is there any setup that I missed?
Any suggestion how to solve this?
Thanks.

Here's some reference ss that I already did.
1. Register Application on Azure

2. Setup Secret Key

3. Setup Permission

4. Already Finish Assisted Setup Azure

5. Already setup the redirect URIs

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Amit Baru 3,037 on at

Like (0)

Report

RE: Business Central on Premise Power BI Integration

Hi,

Refer the below link

https://learn.microsoft.com/en-us/dynamics365/business-central/admin-powerbi-setup

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

RE: Business Central on Premise Power BI Integration

Normally when you follow the steps in the wizard, it should work.

It seems that AAD cannot connect to your BC On Prem, might there be a firewall blocking certain traffic? Are the ODATA ports open/enabled in the NST?

This issue indicates there's a problem with the configuration of the Azure registered application used by the service. The problem is typically caused by incorrect values for either the Redirect URL, Application ID, or Key fields in the application registration. A common problem deals with the redirect URLs. Make sure the Redirect URL matches the redirect URL in the Azure portal and the URL of the Web client. To fix this issue, run the Set Up Azure Active Directory assisted setup and compare the values with the app registration in Azure.

Was this reply helpful? Yes No
Bilal Fazrin 84 on at

Like (0)

Report

RE: Business Central on Premise Power BI Integration

Hi Thank for the reply.

Is there any way I can check whether my BC server can be accessed from the AAD?

I try to to register from Azure Active Directory Application Card, and when I give consent it is successful

I got some error at first saying the reply URI of the Application is not the same as registered on BC.
But it is ok after I change the client base url.

My server is using self signed SSL, does it might also the causes?

Thanks.

Was this reply helpful? Yes No
Suggested answer

Bilal Fazrin 84 on at

Like (1)

Report

RE: Business Central on Premise Power BI Integration

Hi All,

I've found the root cause of the issue.

It's because of the firewall blocking in our network security.

Once we bypass the firewall, it is successfully connected with the AAD.

Now we just have to readjust the firewall policy.

Thank you all for the support.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,696 Moderator on at

Like (0)

Report

RE: Business Central on Premise Power BI Integration

Thanks for the update.

Was this reply helpful? Yes No