Thank you David for writing this up.

Will the Schema-level GRANT command (e.g., GRANT SELECT ON SCHEMA SQLUser TO NS1_Read) also provide "SELECT" privileges to the Views and any Stored Procedures in the schema or only to the tables?

Thanks again

The containers web site is back up and running:

InterSystems Container Repository
 

Thank you for reporting the earlier outage.

An update on this...

I had assumed that all was configured properly on the Report Server, particularly with respect to the required connections and gateways as described here: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

I was mistaken. Also, we are running an older version of the report server (Version 1.12.7981.11681, from Sept. 2021), which does not provide the "New data source and gateway management experience" introduced in May, 2022.

We're planning an upgrade of our Power BI Report Server and backing SQL Server and I'll revisit the use of DirectQuery to IRIS with some of our reports after that upgrade.

Thanks again Carmen for the pointers and I'll update this post after getting this working as expected.