Forum Discussion
Use of views
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
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
1 Reply
- v-yueyunzh-msft
Community Support
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