Forum Discussion

SSWADOOD's avatar
SSWADOOD
Icon for Helper I rankHelper I
3 years ago

Get Data from linked servers in SQL Server in power bi desktop file

Hi, 

 

i have created a (oracle database) linked server in sql server which connects successfully in sql server and also fetches data from different tables in that database aswell.

 

for learning purpose i was trying to get from data from the linked server in powerbi using sql server connector, how can i do that.

 

if i connect to the sql server without entering the server name only it shows me actual databases that are on the server and does not show linked server databases.

 

any idea how can i fetch data from linked server?

 

Thanks & Regards