topic Business Central on Premise Power BI Integration in Developer

Business Central on Premise Power BI Integration

Anonymous — Fri, 30 Sep 2022 09:45:02 GMT

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

Re: Business Central on Premise Power BI Integration

Anonymous — Mon, 03 Oct 2022 09:43:45 GMT

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

Re: Business Central on Premise Power BI Integration

Anonymous — Thu, 20 Oct 2022 09:49:10 GMT

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

Re: Business Central on Premise Power BI Integration

Anonymous — Fri, 21 Oct 2022 01:48:39 GMT

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