Linking Excel 2013 to Microsoft Dynamics (Great Plains) 2013 in Power Query

[otisvillain]

Hey all-

I'm familiar with PQ but cannot seem to be able to link up Excel to Microsoft Dynamics (located on a remote server outside of my office). I've done some reading but cannot seem to get a clear answer.

Any quick ideas on how to do this?

Thank you