Use of views

[Anonymous]

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 

[v-yueyunzh-msft · Accepted 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