Hey @ns_casper when you list catalog/schemas in Excel, it fires off queries to Databricks SQL. Can you see those queries in the Query History? Are there any errors there?
I suspect there is some issue with the underlying catalog that's preventing the...
Hey Wilco,
The answer is no, ODBC/JDBC don't support complex types so these need to be compressed into strings over the wire (usually in JSON representation) and rehydrated on the client side into a complex object.
Are you trying to use Power BI RLS rules on top of DirectQuery?
Can you give an example of the rules you're trying to apply? Are they static roles, or dynamic roles based on the user's UPN/email being in the dataset?
