Forum Discussion
Solved
Connect Linked SQL Server to Power BI Desktop
Background and Problem: I am trying to create a Power BI report using data pulled from MSSQL server to which I have access. I am able to successfully connect to the primary SQL server using the regu...
In your connection definition try running a SQL query against the linked server.
Use the initial server and database for the connection. The database is NOT optional, that dialog title is faulty.
Then run the query as you listed it.
Thank you for that. However, as you can see below, the linked servers do not fall under the any database. For this purpose I am unable to discern what to enter as a database when linking to the SQL server
Pick any database on the original server that you have access to.
Thank you so very much. That worked!