Forum Discussion

Aniko01's avatar
Aniko01
Regular Visitor
2 years ago
Solved

ODBC connection - views

Hi,

 

I am connecting via ODBC to power bi.

I see all the tables (inc views) and would like add and access the database views instead of the actual tables. When I try to select any views, they are empty (I kn ow that the view is a result of an SQL query and it’s a virtual table, so it doesn't store any physical data).

 

do you have any idea how I can use views in power bi?

 

Thank you in advance for any assistance

Need Help
  • AmiraBedh's avatar
    AmiraBedh
    2 years ago


    Often, the issue with empty views in Power BI comes from permission settings. Ensure that the user account you are using for the ODBC connection has sufficient privileges to access the views in the database.

     

    If you are using SQL Server you can refresh the views :

    exec sp_refreshview 'schema.view_name'
     

1 Reply

  • AmiraBedh's avatar
    AmiraBedh
    Super User
    2 years ago


    Often, the issue with empty views in Power BI comes from permission settings. Ensure that the user account you are using for the ODBC connection has sufficient privileges to access the views in the database.

     

    If you are using SQL Server you can refresh the views :

    exec sp_refreshview 'schema.view_name'