Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.

Change country

Modal Close icon
Country selected Country selected
country flag United States
Country selected
country flag United Kingdom
Country selected
country flag India
Country selected
country flag Germany
Country selected
country flag France
Country selected
country flag Canada
Country selected
country flag Russia
Country selected
country flag Spain
Country selected
country flag Brazil
Country selected
country flag Australia
Country selected
country flag Argentina
Country selected
country flag Austria
Country selected
country flag Belgium
Country selected
country flag Bulgaria
Country selected
country flag Chile
Country selected
country flag Colombia
Country selected
country flag Cyprus
Country selected
country flag Czechia
Country selected
country flag Denmark
Country selected
country flag Ecuador
Country selected
country flag Egypt
Country selected
country flag Estonia
Country selected
country flag Finland
Country selected
country flag Greece
Country selected
country flag Hungary
Country selected
country flag Indonesia
Country selected
country flag Ireland
Country selected
country flag Italy
Country selected
country flag Japan
Country selected
country flag Latvia
Country selected
country flag Lithuania
Country selected
country flag Luxembourg
Country selected
country flag Malaysia
Country selected
country flag Malta
Country selected
country flag Mexico
Country selected
country flag Netherlands
Country selected
country flag New Zealand
Country selected
country flag Norway
Country selected
country flag Philippines
Country selected
country flag Poland
Country selected
country flag Portugal
Country selected
country flag Romania
Country selected
country flag Singapore
Country selected
country flag Slovakia
Country selected
country flag Slovenia
Country selected
country flag South Africa
Country selected
country flag South Korea
Country selected
country flag Sweden
Country selected
country flag Switzerland
Country selected
country flag Taiwan
Country selected
country flag Thailand
Country selected
country flag Turkey
Country selected
country flag Ukraine
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Microsoft Dynamics GP 2016 Cookbook

You're reading from   Microsoft Dynamics GP 2016 Cookbook Over 100 powerful and effective recipes to help you solve real-world Dynamics GP problems

Arrow left icon
Product type Paperback
Published in Aug 2016
Publisher
ISBN-13 9781786463401
Length 376 pages
Edition 1st Edition
Tools
Concepts
Arrow right icon
Authors (2):
Arrow left icon
Ian Grieve Ian Grieve
Author Profile Icon Ian Grieve
Ian Grieve
LinkedIn
Ian Grieve is a Microsoft Most Valuable Professional for Microsoft Dynamics GP. He is also a certified Dynamics CRM consultant, specializing in the delivery of Microsoft Dynamics GP. He is the ERP Practice Manager at Perfect Image Ltd., a Microsoft partner, and VAR in the North-East of England, where he is responsible for the delivery, by his team, of all Dynamics GP projects. Ian has worked with Microsoft Dynamics GP since 2003, and over the years, he has dealt with all aspects of the product's life cycle, ranging from presales, implementation, technical, and functional training post go-live support to subsequent upgrades and process reviews. Ian is the author of Microsoft Dynamics GP 2013 Financial Management by Packt Publisihing and Microsoft Dynamics GP Workflow 2.0 and Implementing the Microsoft Dynamics GP Web Client by azurecurve Publishing. He is also the co-author of Microsoft Dynamics GP 2013 Cookbook by Packt Publisihing. Additionally, he has produced the Microsoft Dynamics GP Techniques online learning course and was the technical reviewer for several books on Microsoft Dynamics CRM published by Packt Publishing, including Microsoft Dynamics CRM 2011 Cookbook. In his spare time, Ian runs the azurecurve blog, Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk), which is dedicated to Microsoft Dynamics GP and related products. The most recent offshoot of running his blog is that Ian has started writing plugins to extend the functionality of the blogging platform, WordPress. A new site, azurecurve Development (http://development.azurecurve.co.uk), contains information about his plugins.
Read more
See other products by Ian Grieve
Mark Polino Mark Polino
Author Profile Icon Mark Polino
Mark Polino
Mark Polino is CPA, with additional certifications in financial forensics (CFF) and information technology (CITP). He is a Microsoft MVP for Business Solutions and a GPUG All Star who has worked with Dynamics GP and its predecessors since 1999. He works as the Director of Client Services for Fastpath, and he runs the DynamicAccounting.net website dedicated to all things Dynamics GP. He is a regularly featured speaker at Dynamics GP related events. This is Mark's tenth book, and his seventh GP related book with Packt Publishing. His work includes eight technology-focused books and two novels. He is also the author of the best-selling Microsoft Dynamics GP 2010 Cookbook, the spin off Lite edition, and a co-author for updated GP 2013 and 2016 editions, all from Packt Publishing.
Read more
See other products by Mark Polino
Arrow right icon
View More author details
Toc

Table of Contents (15) Chapters Close

Preface 1. Personalizing Dynamics GP FREE CHAPTER 2. Organizing Dynamics GP 3. Automating Dynamics GP 4. Leveraging New and Updated Features in Dynamics GP 5. Exposing Hidden Features in Dynamics GP 6. Improving Dynamics GP with Hacks 7. Preventing Errors in Dynamics GP 8. Harnessing the Power of SmartLists 9. SmartList Designer 10. Connecting Dynamics GP to Microsoft Office 2016 11. Maintaining Dynamics GP 12. Extending Dynamics GP Professional Services Tools Library 13. Modern Business Intelligence for Dynamics GP Index

Connecting GP to Power BI with OData

Microsoft is making significant investments in its Power BI analytics suite. The free tier of Power BI can be used to connect and analyze information from Dynamics GP via OData. The full range of Power BI functionality is well beyond the scope of this book, but in this recipe we'll see how to make a connection.

Getting ready

Prior to connecting GP to Power BI, a Power BI account needs to be set up. Power BI offers a free tier that can be used for this connection. A Microsoft account is required, but it doesn't have to be a business or an Office 365 account. A personal account also works.

Currently, the option to connect via OData is only available to set up using Power BI Desktop, not Power BI on the web. Power BI Desktop can be downloaded and installed from PowerBI.Microsoft.com. Once visualizations have been built using Power BI Desktop, they can be uploaded to Power BI on the Web. Data can be viewed and updated using Power BI on the Web, but...

lock icon The rest of the chapter is locked
arrow left Previous Section
Section 6 of 7
Next Section arrow right
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Sign up now
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Start free trial
Renews at €18.99/month. Cancel anytime

Authors (2)

Left arrow icon
Profile icon Grieve
Grieve
LinkedIn icon Github icon
Ian Grieve is a Microsoft Most Valuable Professional for Microsoft Dynamics GP. He is also a certified Dynamics CRM consultant, specializing in the delivery of Microsoft Dynamics GP. He is the ERP Practice Manager at Perfect Image Ltd., a Microsoft partner, and VAR in the North-East of England, where he is responsible for the delivery, by his team, of all Dynamics GP projects. Ian has worked with Microsoft Dynamics GP since 2003, and over the years, he has dealt with all aspects of the product's life cycle, ranging from presales, implementation, technical, and functional training post go-live support to subsequent upgrades and process reviews. Ian is the author of Microsoft Dynamics GP 2013 Financial Management by Packt Publisihing and Microsoft Dynamics GP Workflow 2.0 and Implementing the Microsoft Dynamics GP Web Client by azurecurve Publishing. He is also the co-author of Microsoft Dynamics GP 2013 Cookbook by Packt Publisihing. Additionally, he has produced the Microsoft Dynamics GP Techniques online learning course and was the technical reviewer for several books on Microsoft Dynamics CRM published by Packt Publishing, including Microsoft Dynamics CRM 2011 Cookbook. In his spare time, Ian runs the azurecurve blog, Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk), which is dedicated to Microsoft Dynamics GP and related products. The most recent offshoot of running his blog is that Ian has started writing plugins to extend the functionality of the blogging platform, WordPress. A new site, azurecurve Development (http://development.azurecurve.co.uk), contains information about his plugins.
Read more
See other products by Grieve
Profile icon Polino
Polino
Mark Polino is CPA, with additional certifications in financial forensics (CFF) and information technology (CITP). He is a Microsoft MVP for Business Solutions and a GPUG All Star who has worked with Dynamics GP and its predecessors since 1999. He works as the Director of Client Services for Fastpath, and he runs the DynamicAccounting.net website dedicated to all things Dynamics GP. He is a regularly featured speaker at Dynamics GP related events. This is Mark's tenth book, and his seventh GP related book with Packt Publishing. His work includes eight technology-focused books and two novels. He is also the author of the best-selling Microsoft Dynamics GP 2010 Cookbook, the spin off Lite edition, and a co-author for updated GP 2013 and 2016 editions, all from Packt Publishing.
Read more
See other products by Polino
Right arrow icon

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Right arrow icon