Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Евгений
New Member

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?

2 ACCEPTED SOLUTIONS
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@Евгений,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

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?

View solution in original post

3 REPLIES 3
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@Евгений,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Евгений
New Member


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
Not applicable

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?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.