Refresh Error - SSAS_ShortMessage_ProcessingError

Thank you Anonymous  and GilbertQ both for your replies - interestingly, I've changed absolutely nothing, given it another refresh in the service, and am now getting this error:

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [08000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: 'org.apache.hive.service.cli.HiveSQLException: Failed to acquire a SAS token for list on /__unitystorage/catalogs/ID/tables/ID/_delta_log due to java.util.concurrent.ExecutionException: com.databricks.sql.managedcatalog.acl.UnauthorizedAccessException: PERMISSION_DENIED: User does not have SELECT on Table 'TABLENAME'.\n\tat org.apache.spark.sql.hive.thriftserver.HiveThriftServerErrors$$anonfun$sparkOperationError$1.applyOrElse(HiveThriftServerErrors.scala:83)\n\tat org.apache.spark.sql.hive.thriftserver.HiveThriftServerErrors$$anonfun$sparkOperationError$1.applyOrElse(HiveThriftServerErrors.scala:77)\n\tat scala.runtime.AbstractPartialFunction.apply(AbstractPartialFunction.scala:38)\n\tat org.apache.spark.sql.hive.thriftserver.SparkGetPrimaryKeysOperation.execute(SparkGetPrimaryKeysOperation.scala:36)\n\tat org.apache.spark.sql.hive.thriftserver.Spa"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Databricks"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"{\"host\":\"HOSTNAME\",\"httpPath\":\"\\HTTPPATH\"}"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: mql_pbi.
Cluster URI: WABI-NORTH-EUROPE-I-PRIMARY-redirect.analysis.windows.net
Activity ID: 31021b5c-8de1-45ea-bc63-183fdf63577e
Request ID: 78b4d6f0-e4d2-9e88-5f4c-b2fdc532c81e
Time: 2024-03-04 14:27:10Z

I've 100% got permissions to SELECT the table in Databricks as it works with no issue in SQL Editor.

I've censored some Databricks IDs and SQL Warehouse details in the above.

Thanks

Hi James-C 

I will double check that we can successfully connect from the power service via the VNET gateway to your data source.

Hi James-C ,

Please try refreshing the SSAS data source using the standard gateway.Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Hi James-C 

It appears that there is an issue with the connectivity with the connector to Databricks?

Can you see the query getting to your databricks cluster?