Today’s post combines the topics of the previous two posts and moves into Power Query to connect to SQL directly instead of connecting to static, exported SmartLists or flat files.
Previous posts in the series
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