Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to Solution.
@Евгений,
You can write SQL query in the SQL statement textbox as follows when connecting to SQL database in Power BI Desktop.
Regards,
Lydia
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?
@Евгений,
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.
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?