Forum Discussion
SSWADOOD
Helper I
3 years agoGet 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
1 Reply
- amitchandak
Super User
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