Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Aniko01
New Member

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

1 ACCEPTED SOLUTION
AmiraBedh
Resident Rockstar
Resident Rockstar


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'
 

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

View solution in original post

1 REPLY 1
AmiraBedh
Resident Rockstar
Resident Rockstar


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'
 

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.