Power BI, Excel & GP – SQL sources

Today’s post is combining the topics of the previous two posts and moving into Power Query to connect to SQL directly instead of connecting to static, exported SmartLists or flat files.

The previous posts in the series are:

What this post covers

In this post, here is what I am going to show, in the context of the Payables Transactions type of…

Continue Reading Jen Kuntz’s Article on their blog

Power BI, Excel & GP – SQL sources

Today’s post is combining the topics of the previous two posts and moving into Power Query to connect to SQL directly instead of connecting to static, exported SmartLists or flat files. The previous posts in the series are: In this post, here is what I am going to show, in the context of the Payables Transactions type of information I showed in the first post on starting from scratch.

Blog Syndicated with Jen Kuntz’s Permission

More About This Author

Jen Kuntz
Jen Kuntz
Jen is a self-employed Dynamics GP consultant, based in Southwestern Ontario, Canada. She is a Microsoft MVP in Business Applications (since 2016), a GPUG All-Star and a designated accountant (CPA, CGA).

Author: Jen Kuntz

Jen is a self-employed Dynamics GP consultant, based in Southwestern Ontario, Canada. She is a Microsoft MVP in Business Applications (since 2016), a GPUG All-Star and a designated accountant (CPA, CGA).

Share This Post On