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, Parallelism And Dependencies Between SQL Queries In DirectQuery
Mode
-
This is going to sound strange, but one of the things I like about tuning
Power BI DirectQuery semantic models is that their generally-slower
performance a...
4 days ago
No comments:
Post a Comment