Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
Solved! Go to Solution.
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
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,
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
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
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |