While I can get the Power Query to work great for me, as soon as I send it to someone else, they are prompt to enter credentials to access the data.
This would probably work great if the other users had accounts on the SQL Server, but they don't. I have tried setting the Excel Services Authentication Settings to None (which should use the connection string) and then saving the password in the connection string.
Every Google search on Power Query or Data Explorer comes up with the same examples (most by Pragmatic Works - which is the reason I am trying this out in the first place) but no real information on setting up the connection properties or best practices.
Any help would be greatly appreciated. BTW I am using Excel 2010 and SQL Server 2008