As an example, we have Lakehouse A and Lakehouse B.
We have a Calendar Delta Table in Lakehouse A and a OneLake shortcut of this same table over to Lakehouse B. When we create a Semantic Model on Lakehouse B using the Calendar shortcut, we experience some issues when refreshing the Semantic Model.
Direct Lake refresh fails with the following message:
An error has occurred while checking the latest version of the direct lake table <tableName>, error Azure.RequestFailedException: User is not authorized to perform current operation for workspace '<workspaceId>' and artifact '<artifactId>' Status: 403 (Forbidden) ErrorCode: Forbidden Content: {"error":{"code":"Forbidden","message":"User is not authorized to perform current operation for workspace '<workspaceId>' and artifact '<artifactId>'"}} Headers: Access-Control-Allow-Headers: REDACTED Access-Control-Allow-Methods: REDACTED Access-Control-Allow-Origin: * Access-Control-Expose-Headers: REDACTED Transfer-Encoding: chunked x-ms-error-code: Forbidden Strict-Transport-Security: REDACTED X-Content-Type-Options: REDACTED x-ms-root-activity-id: REDACTED Date: Fri, 15 Dec 2023 15:21:52 GMT Server: Microsoft-HTTPAPI/2.0 Content-Type: application/json at Azure.Storage.Files.DataLake.FileSystemRestClient.<ListPathsAsync>d__21.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Azure.Storage.Files.DataLake.DataLakeFileSystemClient.<GetPathsInternal>d__64.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Azure.Storage.Files.DataLake.Models.GetPathsAsyncCollection.<GetNextPageAsync>d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Threading.Tasks.ValueTask`1.get_Result() at Azure.Storage.StorageCollectionEnumerator`1.StorageAsyncPageable.<GetAsyncEnumerator>d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Threading.Tasks.Sources.ManualResetValueTaskSourceCore`1.GetResult(Int16 token) at Microsoft.ASWL.Service.Engine.SeethruAutoSync.DirectLakeTable.<FetchTableVersionAsync>d__30.MoveNext() in /_/ASWL.Service/Engine/SeethruAutoSync/DirectLakeTable.cs:line 107 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.ASWL.Service.Engine.SeethruAutoSync.DirectLakeTable.<FetchTableVersionAsync>d__30.MoveNext() in /_/ASWL.Service/Engine/SeethruAutoSync/DirectLakeTable.cs:line 107.
A manual refresh works, but will sometimes fail was well, with a similar error, mentioning Unauthorized access to the
