Forum Discussion

Pitchaimuthu's avatar
Pitchaimuthu
Helper II
9 years ago
Solved

How to Connect Live connection on SQL server to Power BI?

I could not able to connect to the live connection on sql server to power bi desktop. It is showing the error below my screen.  I have the data in sql server. So whenever I am trying to live connection on sql server to power bi below the error is showing. I do not want to connect to the import query model to connect. why because I have large amount of data. So that I am trying to connect live connection between sql server and Power bi. Please give how to solve this issues. 

 

 

  • You can only connect to a single data source when using Direct Query. From the error message, you are trying to connect to two different SQL sources.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    You can only connect to a single data source when using Direct Query. From the error message, you are trying to connect to two different SQL sources.