how to show power bi report in MS dynamic nav 2017 ?

[AnandRanga]

I want to show Power BI chart in navision 2017, for that I am following this link:

https://community.dynamics.com/nav/b/fajdigainfo/archive/2016/10/30/how-to-enable-microsoft-powerbi-...

My prob is, When i am trying to setup Azure active directory on portal.azure.com. It asks me for sign-on url and the url I am entering the value in this is what i got from navision 2017 setup azure active directory.

I am getting this from reply url in nav 2017 setup azure active directory: 

http://mypcname:48900/DynamicsNAV100/WebClient/OAuthLanding.htm

If I am trying to open  this link  in my chrome, it shows nothing and says 

This site can’t be reached

because my web client is working on 8080 port. so when I complete the whole process which includes granting the permission to azure app name, It shows the error that reply url doesn't match with http://mypcname:48900/DynamicsNAV100/WebClient/OAuthLanding.htm

I dont know from where 48900 is coming and why it's not working and says site can't be reached.

What i am missing?

 Needs guidance,Thanks for your time.

[v-caliao-msft]

Hi @AnandRanga,

For the license issue, we can choose to use a free account, a Pro trial account, or purchase Power BI Pro, even if you are in an existing organization. Power BI requires that you use a work, or school, email address to sign up. Power BI does not support email addresses provided by consumer email services or telecommunication providers. This includes outlook.com, hotmail.com, gmail.com and others.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-self-service-signup-for-power-bi/

With Power BI Publish to web, you can easily embed interactive Power BI visualizations online, such as in blog posts, websites, through emails or social media, on any device.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-publish-to-web/

Regards,

Charlie Liao

[AnandRanga]

thanks @v-caliao-msft

any idea how to configure azure active directory for the same.

[nikhilrajgupta · Accepted solution]

Hi,

I got this issue resolved and now Embedded Power BI is running fine from my local machine.

All the steps in the document you mentioned Anand are correct. You need to do the following for making it work:

1) In the Reply URL for App in Azure, specify the URL with the port you are running your web client on. For e.g. i am running web client on port 8080 on my local machine. so the URL i entered in my Reply URL was:

http://admin-pc:8080/DynamicsNAV100/WebClient/OAuthLanding.htm

2) Now open NAV 2017 and go to the table "Azure AD App Setup" (6300) and in the Redirect URL field, change the URl to the same as used above in Azure.

Now go to RTC or Web Client and you will be autheticated to use Embedded Power BI without any issue.

Cheers!!

Nikhil Raj Gupta

[Anonymous]

hi , actualy the enitre section which shows homepage url, reply url,app id, key is missing suddenly from azure active directory setup in nav.

how would i make them come back.

Actually i registered my apllication, but now when i want to change the reply url. The entire part of url tabs ar emissing.

say , now when i click aad setup in nav , it shows only few writings and auto register option.

thats it.