back to notes

ODBC Connection

Here is (an albeit clunky) workaround.

If you can access the data via Reporting services, you can then use the Reporting Services report as a data source for Power Query (via oData). It's not ideal, but it should get the job done. You can use SSRS to reshape the data for end users. SSIS can also be used in a similar manner.

Cheers

AWS Reporting
AWS connectwise