Tag: Business Intelligence

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.”

SmartList Search Options – Maximum Records & Search Types (And/Or Logic)

As part of a SmartList Search series (which can be found here), we will discuss the search options available in the search window.

Search options are found at the bottom of the SmartList search window.  There are two options available; Maximum Records and Search Type.  In addition to these two options, I will also talk about the three buttons below the search options (Clear All, Columns, Order By).

Continue reading “SmartList Search Options – Maximum Records & Search Types (And/Or Logic)”

GP #LifeHacks 163: Smartlists gone WILD!! Search Functionality explained

One of the MANY things that sets Dynamics GP apart from other ERP solutions… SMARTLISTS BABY!!!

Smartlists are a linear list of your data.  You can customize them easily but out of the box, there are lists for all transactions, vendors, customers, and TONS of other things.

With the SmartList tool (free/included with Microsoft Dynamics GP) you have the ability to do some valuable filtering of your data… this filtering is made available through data ‘Search’ options.

A simple search example would be, show me all the transactions for Vendor XYZ… and BOOM, there they are… but what if your search is a little more complex that that?  Let’s take a look at the options for basic and advanced search functionality.

Continue reading “GP #LifeHacks 163: Smartlists gone WILD!! Search Functionality explained”

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”

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 – 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 & 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 & 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”

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”