cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bilalfazrinxc6
New Member

Business Central on Premise Power BI Integration

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...
https://learn.microsoft.com/en-us/azure/active-directory/develop/quickstart-register-app#add-a-clien...

I am currently stuck when trying to Authorize Azure Services

 

bilalfazrinxc6_8-1664530699265.png

 



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

 

bilalfazrinxc6_9-1664530738663.png

 

 



2. Setup Secret Key

 

bilalfazrinxc6_10-1664530775166.png

 

 



3. Setup Permission

 

bilalfazrinxc6_11-1664530875518.png

 

 



4. Already Finish Assisted Setup Azure

 

bilalfazrinxc6_12-1664530891053.png

bilalfazrinxc6_14-1664531000141.png

 

 

 

 

 



5. Already setup the redirect URIs

 

bilalfazrinxc6_15-1664531014940.png

 

 



2 ACCEPTED SOLUTIONS
yingyinr
Community Support
Community Support

Hi @bilalfazrinxc6 ,

Accroding to the error message, it seems that  it stucked in Set Up Azure Active Directory step. Did you authoticate

Business Central Users with Azure Active Directory? 

Authenticating Business Central Users with Azure Active Directory

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


Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

bilalfazrinxc6
New Member

Hi, 

Thanks for the reply.
Unfortunately the rootcause is our insfrastructure connection firewall that blocked the OData Port.|
Once they bypass the firewall limitation, BC successfully conntected to AAD.
After that we just have to rearrange the firewall policy.

Thanks 
Best Regards,
Bilal Fazrin

View solution in original post

3 REPLIES 3
bilalfazrinxc6
New Member

Hi, 

Thanks for the reply.
Unfortunately the rootcause is our insfrastructure connection firewall that blocked the OData Port.|
Once they bypass the firewall limitation, BC successfully conntected to AAD.
After that we just have to rearrange the firewall policy.

Thanks 
Best Regards,
Bilal Fazrin

Hi @bilalfazrinxc6 ,

It's glad to hear that your problem has been resolved. And thanks for sharing the cause of problem and solution. It will help the others in the community find the solution quickly if they face the similar problem as yours. Thank you.

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
yingyinr
Community Support
Community Support

Hi @bilalfazrinxc6 ,

Accroding to the error message, it seems that  it stucked in Set Up Azure Active Directory step. Did you authoticate

Business Central Users with Azure Active Directory? 

Authenticating Business Central Users with Azure Active Directory

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


Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.