From Sean Dorward: Unable to connect to the PowerBI Site to your Microsoft Dynamics GP

The following is a terrific post from Microsoft Dynamics GP MVP, Shawn Dorward.

The following is a terrific post from Microsoft Dynamics GP MVP, Shawn Dorward.

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…

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

Using Relative Date Filtering in Microsoft Power BI

In this video, I demonstrate using Relative Date Filtering in Microsoft Power BI. My dataset contains unpaid Accounts Payable invoices and their due dates. I use the Filter options to restrict the visual to display only invoices that are in the next 275 weeks. My sample data is way out in the future, realistically, you would want to see what’s due this week, month, etc.

Check out this blog post from my www.BIBelinda.com blog.

 

Continue reading “Using Relative Date Filtering in Microsoft Power BI”

Obtaining Microsoft Dynamics GP Employee Head Count (Part 4) in Power BI (Video)

This 9-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the Historical Payroll Checks in Microsoft Power BI.

Last week a Microsoft Dynamics GP user asked a question in the user group form www.GPUG.com about obtaining the employee Head Count in Power BI.  I offered a suggestion and another user offered a different suggestion.  I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant. 

Part 4 of a 4-Part Series

This 9-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the Historical Payroll Checks in Microsoft Power BI.

Continue reading “Obtaining Microsoft Dynamics GP Employee Head Count (Part 4) in Power BI (Video)”

Obtaining Microsoft Dynamics GP Employee Head Count (Part 3) in Power BI (Video)

This 15-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the General Ledger Unit Accounts in Microsoft Power BI.

Last week a Microsoft Dynamics GP user asked a question in the user group form www.GPUG.com about obtaining the employee Head Count in Power BI.  I offered a suggestion and another user offered a different suggestion.  I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant. 

Part 3 of a 4-Part Series

This 15-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the General Ledger Unit Accounts in Microsoft Power BI.

Continue reading “Obtaining Microsoft Dynamics GP Employee Head Count (Part 3) in Power BI (Video)”

Obtaining Microsoft Dynamics GP Employee Head Count (Part 2) in Power BI (Video)

This 8-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the Employee Maintenance data in Microsoft Power BI.

Part 2 of a 4-Part Series

This 8-ish minute video shows how I performed the data modeling and visual creation of the Microsoft Dynamics GP Employee Head count using the Employee Maintenance data in Microsoft Power BI.

Last week a Microsoft Dynamics GP user asked a question in the user group form www.GPUG.com about obtaining the employee Head Count in Power BI.  I offered a suggestion and another user offered a different suggestion.  I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant. 

Continue reading “Obtaining Microsoft Dynamics GP Employee Head Count (Part 2) in Power BI (Video)”

Obtaining Microsoft Dynamics GP Employee Head Count (Part 1) in Power BI (Video)

Last week a Microsoft Dynamics GP user asked a question in the user group form http://www.GPUG.com about obtaining the employee Head Count in Power BI.  I offered a suggestion and another user offered a different suggestion.  I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant. 

Part 1 of a 4-Part Series

Last week a Microsoft Dynamics GP user asked a question in the user group form www.GPUG.com about obtaining the employee Head Count in Power BI.  I offered a suggestion and another user offered a different suggestion.  I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant.

Last week a Microsoft Dynamics GP user asked a question in the user group form www.GPUG.com about obtaining the employee Head Count in Power BI.  I offered a suggestion and another user offered a different suggestion.  I thought about it over the weekend and realized this would be a great opportunity to review the importance of knowing your data, or being a Data Consultant. 

This 8-ish minute video reviews the Pros and Cons of 3 different method of obtaining the employee head count.  I review the method the initial user (who asked the question) used and the two recommendations that another user and I provided.

Continue reading “Obtaining Microsoft Dynamics GP Employee Head Count (Part 1) in Power BI (Video)”

Using Microsoft Excel to create a Dynamics GP auto refreshing report (Video)

Last week, a Microsoft Dynamics GP User (Glenda) asked about making an Excel Refreshable Report refreshable.  She not only wanted the table to refresh, but she wanted the associated PivotTable to refresh as well. 

Last week, a Microsoft Dynamics GP User (Glenda) asked about making an Excel Refreshable Report refreshable.  She not only wanted the table to refresh, but she wanted the associated PivotTable to refresh as well.

Microsoft Dynamics GP User Group.

Continue reading “Using Microsoft Excel to create a Dynamics GP auto refreshing report (Video)”