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
The fourth post in the series, showing how to connect to SQL in Power Query (Excel or PowerBI).
Blog Syndicated with Jen Kuntz’s Permission