Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

PowerBI

(1) ShareShare
ReportReport
Posted on by 5

Hello,

Has anyone encountered an issue with Dynamics GP 2016 R2 in having the Reporting Tools Setup accept the login to PowerBI.  It worked at the beginning but then for some reason it cannot login anymore "This login failed. Attempt to login again or contact your system administrator".  

I can connect to the PowerBI site with no problem, generate the Client ID with no problem.  But GP still cannot login with that key.

Any ideas?

Thanks

*This post is locked for comments

  • Suggested answer
    ShawnMD Profile Picture
    1,456 User Group Leader on at
    RE: PowerBI

    If you haven't figured this out - check out this write up - it might help:

    gplifehacks.com/.../dynamics-gp-power-bi-resolve-error-this-login-failed

  • Wassim Rahme Profile Picture
    5 on at
    RE: PowerBI

    No I gave up and stopped investigating.  Good luck with your investigation.

  • Joe Critchlow Profile Picture
    1,145 on at
    RE: PowerBI

    I am having the same issue, did you ever get this resolved.

    Joe

  • Wassim Rahme Profile Picture
    5 on at
    RE: PowerBI

    Thank you Kirk for your reply.  I'll continue investigating using your hints.

    wassim

  • KirkLivermont Profile Picture
    5,985 on at
    RE: PowerBI

    The GP Application uses the odbc connection string as part of the password encryption. If you login to GP as 'sa' and reset the user password it will work for GP again but will no longer work for PowerBI. If you reset the password in SQL I believe it will begin working for PowerBI but will no longer work to login to the GP Application. The last time I used PowerBI I authenticated to SQL via my AD account.

    Kirk

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans