Hi All,

We recently migrated the on-prem database to Fabric & now some of the connections of that Access application needs to change to the Fabric Warehouse.

Using the ODBC driver, this seems to work, the only issue is that it looks like the user that is using the application has to have "VIEWER" access on the workspace, otherwise the connection cannot be successfully performed.

We've tried by removing the viewer access, and giving granualar connect + readData permission on the specific warehouse, but this throws a connection error (even before we can select a warehouse).
It seems like it needs to have "connect" permissions on the "server".

Does anyone have experience with this set-up? Best practices? Service principal,... doesn't seem an option at first sight.

Thanks !