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 Copilot AI Instructions: Helping Users Understand The Scope Of The
Data
-
Continuing my series of posts on Power BI Copilot and the type of things
you should be including in AI Instructions, today I want to talk about
helping the...
13 hours ago
No comments:
Post a Comment