undefined

[Евгений]

Hello world 🙂

Please, help me with PBI and SQL server:

i need connected my PBI with SQL server with some specific query - i found how i can connected into my SQL database, but i need use some query, not just table from this server. How can i do this?

[v-yuezhe-msft · Accepted solution]

@Евгений,

You can write SQL query in the SQL statement textbox as follows when connecting to SQL database in Power BI Desktop.


Regards,
Lydia

[v-yuezhe-msft · Accepted solution]

@Евгений,

You can write SQL query in the SQL statement textbox as follows when connecting to SQL database in Power BI Desktop.


Regards,
Lydia

[Евгений]

Please, help me with PBI and SQL server:
i need connected my PBI with SQL server with some specific query - i found how i can connected into my SQL database, but i need use some query, not just table from this server.

[Anonymous · Accepted solution]

On the screen where you select your SQL server and Database, there is an Advanced Options that can be pressed to review some text boxes.  One of the Text Boxes is "SQL Statement".  I believe that is what you are looking for?