You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The stored procedure has an issue for join_derived_tables section.
In this derived tables query section, 'WHERE TABLE_SCHEMA = @source_table_schema' should be used instead of 'WHERE TABLE_SCHEMA = @target_table_schema'. When @target_table_schema' is not equal to 'dbo', the other base tables which has 'dbo' schema as default fails.
The stored procedure has an issue for join_derived_tables section.
In this derived tables query section, 'WHERE TABLE_SCHEMA = @source_table_schema' should be used instead of 'WHERE TABLE_SCHEMA = @target_table_schema'. When @target_table_schema' is not equal to 'dbo', the other base tables which has 'dbo' schema as default fails.
https://github.com/microsoft/Dynamics-365-FastTrack-Implementation-Assets/tree/master/Analytics/DataverseLink/FabricLink_SQLAnalyticsEndpoint#a-create-stored-procedure-on-lakehouse-sql-analytics-endpoint
The text was updated successfully, but these errors were encountered: