Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    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

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

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