Dynamics Community Forum Thread Details

Switch user accounts for Power BI Embedded in NAV 2017

Hi Reader,

I've currently managed to display Power BI reports in NAV 2017. This is a local installation of NAV (not web). To do so i've registered the app in Azure and logged into a specific power bi user account as part of the process (https://community.dynamics.com/nav/b/fajdigainfo/archive/2016/10/30/how-to-enable-microsoft-powerbi-in-nav-2017). I want to switch the power bi account of the user i'm currently using and log in with another power bi account. I cannot find documentation anywhere on how to do so, also cannot find a solution within NAV 2017. Can anyone tell me how to switch the useraccount?

Initially i posted my question on the Power BI Community forum, a moderator referred me to this forum. Hope one of you guys can help us out! I would very much appreciate it. Thanks!

Hello, I'm not sure if this is still an issue for you because the initial post is older than a year, but finally I have found the solution to this after I faced the very same problem for months. At some point this week I thought of the first steps to activate Power BI in the NAV rolecenter. It's creating an app registration in Azure. Switching users has everything to do with this app but don't worry. You don't have to recreate the app to fix this.

Here is how to do it:

Login to your Office 365 portal via portal.office.com or something simillar. You can also get there via your webmail. Just click the gear in the right top of your screen and click on Office 365 under 'your app settings'. You will be redirected to your own Office portal.
On the left side of the screen there are a few options. One of them is called app-permissions. Click this menu.
- You can see all the app permissions you have right here.
- Notice the blue link 'my apps' on top of your screen where you also find some information about the page. You need this link after step 3
AND HERE IS THE FUN PART:
- Remember the name of the app registration you created in Azure for Power BI in NAV2017?
- You will find this name here as well.
- Under the app, you will find 2 options: Revoke and Details. Simply click on Revoke and you won't have permissions anymore for this particular app.
Ok so now click the 'my apps' link on top of the page. You will be redirected to another page with all of your apps.
Notice the, somewhat hard to see, light grey line somewhere in the middele of your screen.
- Below this line, look for the app registration which you revoked in step 3.
- If you can find it, delete it by hoovering over the app, click the 3 dots and select delete.
- If you cannot find it then you either should look harder or you might be good to go from here.

Now don't rush to restart you NAV2017 client and see if it worked or not because you will find yourself getting frustrated that all the above steps didn't help.

Even though today everything goes really really fast, you should give Microsoft around 60 minutes tops to synch and update the connections.

If after 60 minutes still nothing happened, put it to rest and check again the next morning. If it still hasn't worked in the morning, you might have revoked the wrong app or there is some other issue.

For me the above steps worked and now I can simply login with another Power BI user / Office 365 user.

Good luck!

Quick Links