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.
Power BI And Support For Third Party Semantic Models
-
I’ve been working with Microsoft BI tools for 28 years now and for all that
time Microsoft has been consistent in its belief that semantic models are a
goo...
2 days ago
No comments:
Post a Comment