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.
Connecting Power BI Semantic Models To Data Sources Automatically With
Binding Hints
-
Did you know that you can configure your Power BI semantic model so that it
automatically binds to a data source connection when you publish? To
illustrate...
4 weeks ago
No comments:
Post a Comment