External Datasouce Excel

[gpayne (Greg Payne)]

@tmayfield Here is a thread from a few weeks ago on this with a lot of options.

Pulling BAQ into Excel - Web API, OData, JSON?

Oh I wish I’d seen this sooner! This is what I get for being busy all day. I LOVE power query and M language, it’s as powerful as it is underutilized. Here’s my contribution to the snippet pile: Some time ago I got tired of trying to visually parse oneliner Web.Contents URL’s, plus concatenating a oneliner URL often throws M and Power [Query,BI] security scope errors, not to mention the special hell that is trying to do this through the gui. So I hashed it out a reliable method from Microsoft’s…