I had an issue in getting GP 2016 R2 set up with Power BI on the Home Page. I worked with Microsoft to resolve the issue. This is what the gifted and dedicated engineer came up with. I’m documenting it here so I can find it again:
“I have determined that since Dynamics GP 2016 R2, the have moved the user token storage from a file in the temporary folder to a table called syADALTokenCache in the Dynamics system database. This table seems to store the login credential, time the token was generated and the actual token.
So to conclude, usually the content of the syADALTokenCache is either delete or updated with the new token information when it expires. But for some unknown reason (the reproduction steps that I need to determine) this token is occasionally left untouched – and attempts to use the expired token for login when attempting to enter the Client ID in the PowerBI setup window. This results in the error message you were receiving.
Try clearing out the content of this table in your environment and see what happens.
Also as a side note, there is another bug I am working on, but essentially, make sure:
- To check the Using Web Client option
- Enter the following URL in the Reply/Redirect URL to fully enable Power BI: https://login.live.com/oauth20_desktop.srf”
Also this is my go-to blog post about setting up Power Bi for GP 2016 R2: