Forum Discussion

jpanzeca's avatar
jpanzeca
Advocate I
8 years ago

specifying linked server

Can I specify a linked server in the data source settings?   I am able to write queries in SSMS by specifiying the linked server in the query.       SELECT * FROM [linked server name].[data base ...
jpanzeca's avatar
jpanzeca
Advocate I
8 years ago

Thanks Sonny,

 

I had tried that before and received the following error...

    The key didn't match any rows in the table.

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
8 years ago

jpanzeca,

 

I had tried that before and received the following error...

    The key didn't match any rows in the table.

This error indicates that we cannot query linked server directly in Power BI. And to work around this issue, we need to create an ODBC connection and then changing each query to use the ODBC connection and the sql query as you sauid.

 

If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Thank you for your understanding.

 

Regards,

Charlie Liao