Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
v-yiruan-msft
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.
v-yiruan-msft
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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors