There are two things I did to fix the error. I'm not sure why. But it worked.
1. On the linked server configuration screen select Be made using this security context. Then put in the SQl Authentication user name and password setup on the remote server.
2. Do NOT use the Run As User option. For some reason, eventhough the specified user can excute the stored proc without any problem, when run it in a scheduled job. It will fail.
Role-Playing Dimensions In Fabric Direct Lake Semantic Models Revisited
-
Back in September 2024 I wrote a blog post on how to create multiple copies
of the same dimension in a Direct Lake semantic model without creating
copies o...
1 week ago
No comments:
Post a Comment