Excel Magic Trick 1385: Import Tables from SQL Server Database into Power Pivot or PBI Data Model #
About The Author
Excel is my Passion and VBA Love of Life. I like to solve and automate any possible opportunity in Excel including in combination with Office Applications (Access, Outlook, Word, PowerPoint, Visio, etc) and other Non-Office Applications (SAP, IE, Batch, Configuration Management Tools, etc). Note: All the solutions given here are published after thoroughly tested to my knowledge, however it is advised to keep a copy before you try it.