Ninmonkey.PowerQueryLib VS DataConnectors

I'm guessing you're using reference or a lot of functions? I wrote a script that reads a bunch of files that are 1 function per file. Then it merges it as one big record-expression like this PowerQueryLib.pq

Here's an example testing SSL Errors in Powerquery.pq . I Need to update that, it was written before try catch existed.

github.com/Ninmonkey.PowerQueryLib/ninlib.pq -- note, that's an older version I've been meaning to update -- but I thought you'd be interested

List.ContinuousDates.pq I'm not sure on the name, I needed something to show it's going to generate a valid datetable

github/ninmonkey/List.ContinuousDates.pq

ninlib.pq

WebRequest_Simple.pq

If you take this function: https://github.com/ninmonkey/Ninmonkey.PowerQueryLib/blob/master/source/WebRequest_Simple.pq

using For(x=0; x<5; x++) loops in Power Query

Hello world example here: https://github.com/microsoft/DataConnectors

Over the past couple of days I was not able to do this using the Sql.Database() function, but I did find an ODBC DirectQueryForSQL sample under github.com/microsoft/DataConnectors that I was able to modify to do this. I would prefer to Sql.Database() so we don't have the SQL Native Client ODBC driver as prerequisite, so I am still trying to wrap my head around the authentication issues I had doing it that way, but I seem to have cleared my first couple of hurdles and am doing okay for now.

docs: https://github.com/Microsoft/DataConnectors/tree/master/samples/HelloWorld