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
More About This Author
- 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).
Array
- Dyn365GP30 March 2024Planes, Trains & Automobiles!
- Dyn365GP26 March 2024Decimal Places for HR Benefits
- Dyn365GP21 March 2024New MS Learn AI Skills Challenge
- Dyn365GP4 March 2024Restoring a copy of a GP company reminder