Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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-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

 

 

 



  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    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

  • Anonymous's avatar
    Anonymous
    3 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous ,

      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