Forum Discussion
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_DecklerCommunity 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.