This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
We created views in a specific schema and want to use these views in PBI.
When connection to the database all the tables show but no views. Accessing the database views with another sql client and the same credentials do work .
Looking at different posts on the web this should work.
Is there a way out of this.
Thanks in advance
Solved! Go to Solution.
Hi, @Anonymous
Based on my understanding on this product, the way for us to connect to views in the SQL Server datasource in the Power BI is to use the "Native query" advanced option to connect to it, you can copy the SQL statement in the view and paste it into the text box:
Please feel free to check this official document:
Import data from a database using native database query - Power Query | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi, @Anonymous
Based on my understanding on this product, the way for us to connect to views in the SQL Server datasource in the Power BI is to use the "Native query" advanced option to connect to it, you can copy the SQL statement in the view and paste it into the text box:
Please feel free to check this official document:
Import data from a database using native database query - Power Query | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 27 | |
| 26 | |
| 22 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 48 | |
| 46 | |
| 41 | |
| 21 | |
| 18 |