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

[SSWADOOD]

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

[amitchandak]

@SSWADOOD , if you can write a sql or SP that can read data from linked server, you can try that

refer:

https://intellipaat.com/community/3763/how-to-use-sql-server-stored-procedures-in-microsoft-powerbi

https://databear.com/sql-stored-procedures-in-power-bi/