Tag: dynamics

Come See Me at Dynamics Con: Business Central Lifehacks

About my session:

Business Central Lifehacks

Fast, Fun and FULL of tips and tricks! This session is all about Business Central, for the end user, by an end user! 100% Free to attend, register and vote for sessions here!

Session Description:

This fast but effective session will have something for every user to improve your Business Central experience. From personalization’s to date formatting, scheduling payments to recurring batches, tips/tricks, recently added features, and much more! We’ll cover fast, fun and cool things to get you and your organization on the right track to use the system in an efficient manner!

Please Register and Vote

As I mentioned, this event is 100% Virtual and 100% Free… but you need to register and vote! Check it out here and I will see you there!

About Dynamics Con

Like many things, conferences are moving more and more virtual. It’s not the same, but it’s better than nothing, and I happen to particularly like this brand new format and virtual conference, Dynamics Con. It’s a Dynamics 365 virtual conference we 3 cool components:

  1. It’s 100% Free
  2. Sessions are voted on by attendees, top sessions make the cut
  3. Proceeds benefit #COVID19 Relief

It’s the inaugural year for the event and I think it is off to a great start and I am happy to participate… but I need your help!!

PLEASE REGISTER AND VOTE!! 🙂 It’s free, 100%!!!


Thanks for reading!

Shawn Dorward

Microsoft MVP, Business Applications

LifeHacks365.com | LinkedIn | Twitter

Come See Me at Dynamics Con: The Power of Power BI

About Dynamics Con

Wow, it’s amazing to think about how long it’s been since I attended an in person conference. It hasn’t ACTUALLY been that long but for someone who is used to attending 6 a year, it feels like forever… and I miss it, a lot!

Like many things, conferences are moving more and more virtual. It’s not the same, but it’s better than nothing, and I happen to particularly like this brand new format and virtual conference, Dynamics Con. It’s a Dynamics 365 virtual conference we 3 cool components:

  1. It’s 100% Free
  2. Sessions are voted on by attendees, top sessions make the cut
  3. Proceeds benefit #COVID19 Relief

It’s the inaugural year for the event and I think it is off to a great start and I am happy to participate… but I need your help!!

PLEASE REGISTER AND VOTE!! 🙂 It’s free, 100%!!!

About my session: The POWER of Power BI

This is THE session to get you started with Power BI. We will cover Power Query and the Power BI Desktop. It’s an intro, but at the right pace, and preparing you for the next step on your journey.

Session Description:

So you have data… and a vision for how you can use it to make quick, impactful decisions… but DRAT… you don’t know where to begin your PBI journey… look no further! During this POWERFUL intro to the most impactful part of Power BI, we will perform a walk-through of Power Query and the Power BI desktop application. How do I connect to data? How do I clean my data? How do I combine my data? And OH, how to take that data, and turn it into a bat signal… I mean, Business Intelligence! This session will get you started on your superpower journey… come join us!! New LifeHacks channel… new LifeHacks time… same great content!

Please Register and Vote

As I mentioned, this event is 100% Virtual and 100% Free… but you need to register and vote! Check it out here and I will see you there!


Thanks for reading!

Shawn Dorward

Microsoft MVP, Business Applications

LifeHacks365.com | LinkedIn | Twitter

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”

GP #LifeHacks 137: Add a SQL View to Smartlist using Designer

Dynamics GP offers a very good tool to create your own Smartlists… Smartlist Designer.
One of the cool things users can do is incorporate custom SQL views into Smartlist through SmartList designer… this can be a HUGE time saver and really gives you the ability to get data you would normally not be able to get in a normal Smartlists.
Below are the steps needed to add a SQL View to your Smartlists.
Continue reading “GP #LifeHacks 137: Add a SQL View to Smartlist using Designer”

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 & 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 & Power BI – Connecting GP OData to Power BI Desktop

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 Dynamics GP OData to Power BI

Step 1:  Install Power BI Desktop (you will need an account as well).

Continue reading “Dynamics GP & Power BI – Connecting GP OData to Power BI Desktop”

Dynamics GP & Power BI – Configure OData Service in Dynamics GP

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 Configure the OData Service in Dynamics GP

Step 1:  Navigate to Reporting Tools Setup

Continue reading “Dynamics GP & Power BI – Configure OData Service in Dynamics GP”