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