Tag: Great Plains

#GPLifeHacks, Dynamics GP

Come Join Me! GP Panel – Sales – Summit NA 2023!

About this Session: Dynamics GP Sales Panel

Title:

Dynamics GP Panel | Ask Us Anything – Sales

Description:

In these Ask Us Anything Sessions, we gather a collection of subject experts together to answer YOUR questions about the subject. In this interactive audience session, your participation in both questions and answers makes this a truly customer helping customer conference. So come with your questions and your own experiences to be part of the greater good.

Continue reading “Come Join Me! GP Panel – Sales – Summit NA 2023!” →
Dynamics GP, Dynamics GP & Power BI (2018RTM), GP2018 RTM, How to, New Features, Power BI

Dynamics GP & Power BI – Unable to connect to the Power BI site. Contact your system administrator.

This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality.  This write up was done using Dynamics GP 2018.
To view the full list of the series, click here.
How to resolve the error:

Unable to connect to the PowerBI Site. Contact your system administrator.

So, you’ve done all the setup and you are ready to get Power BI on your GP Dashboard but when entering into the home screen customization window, you get a blank screen with a very misleading message…  Unable to connect to the Power BI site.  Contact your system administrator.
reached out to me with this roadblock, and I’m glad she did!  I wasn’t sure how to fix this but we figured it out and I am happy to share the solution with my readers!
Continue reading “Dynamics GP & Power BI – Unable to connect to the Power BI site. Contact your system administrator.” →

Dynamics GP, Dynamics GP & Power BI (2018RTM), GP Series, GP2018 RTM, New Features, Power BI

Dynamics GP & Power BI – An Error Has Occurred In The Script On This Page

This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality.  This write up was done using Dynamics GP 2018.
To view the full list of the series, click here.
How to resolve “An error has occurred in the script on this page.” Error when hovering over Power BI within Dynamics GP

Continue reading “Dynamics GP & Power BI – An Error Has Occurred In The Script On This Page” →

#GPLifeHacks, Dynamics GP

GP #LifeHacks 113: Resetting Forgotten System Password

Some of the administrator type functions in Dynamics GP use a system password in order to provide a thin layer of protection against unintentional and/or inappropriate use.
This password often gets misplaced, forgotten, or just disappears with turnover.
I have some good news for you if you fall into this situation… A SQL Script can be used to reset the password.
Continue reading “GP #LifeHacks 113: Resetting Forgotten System Password” →

Dynamics GP

Looking for the MS Connect replacement for Dynamics GP?

The MS Connect site, which was the one-stop repository for ideas/suggestions/bug fixes relating to Dynamics GP (among other things) was retired not too long ago.
Since then, I have had many discussions, online and in person, regarding its replacement. And so far, the replacement was ‘in the works’… until now.
Continue reading “Looking for the MS Connect replacement for Dynamics GP?” →

Dynamics GP, Dynamics GP & Power BI (2018RTM), GP2018 RTM, New Features, Power BI

Dynamics GP & Power BI – Resolve Error: This login failed

This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality.  This write up was done using Dynamics GP 2018.
To view the full list of the series, click here.
How to resolve “This login failed. Attempt to login again or contact your system administrator” error when connecting to Client ID

Continue reading “Dynamics GP & Power BI – Resolve Error: This login failed” →

Dynamics GP, Dynamics GP & Power BI (2018RTM), GP2018 RTM, New Features, Power BI

Dynamics GP & Power BI – How to delete APP registrations

This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality.  This write up was done using Dynamics GP 2018.
To view the full list of the series, click here.

How to delete APP registrations

Continue reading “Dynamics GP & Power BI – How to delete APP registrations” →

Dynamics GP, Dynamics GP & Power BI (2018RTM), GP2018 RTM, New Features, Power BI

Dynamics GP & Power BI – Publish using a custom SQL View

This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality.  This write up was done using Dynamics GP 2018.
To view the full list of the series, click here.

How to publish a custom SQL View to Power BI

Continue reading “Dynamics GP & Power BI – Publish using a custom SQL View” →

Dynamics GP, Dynamics GP & Power BI (2018RTM), GP2018 RTM, New Features, Power BI

Dynamics GP & Power BI – How to see Apps registered to your account

This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality.  This write up was done using Dynamics GP 2018.
To view the full list of the series, click here.
How to see registered Apps on your Power BI account

Step 1: Visit portal.azure.com

Continue reading “Dynamics GP & Power BI – How to see Apps registered to your account” →

Dynamics GP, Dynamics GP & Power BI (2018RTM), GP2018 RTM, New Features, Power BI

Dynamics GP & Power BI – Power BI on your GP Home Screen

This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality.  This write up was done using Dynamics GP 2018.
To view the full list of the series, click here.
How to connect Power BI to GP Home Screen

Dynamics GP can display reports that are pinned to a dashboard in Power BI.  After following these instructions, if you do not see any available reports, be sure to add them to a Dashboard in Power BI.  I created a Dashboard called GP PBI (in Power BI) and only pinned the reports that I wanted to optionally display in Dynamics GP.

Step 1: Obtain Client ID

Continue reading “Dynamics GP & Power BI – Power BI on your GP Home Screen” →