cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

SQL Views not showing in list

I hope there is a quick answer to this. 

 

I have made 2 Views in my Azure SQL, but they dont show up in the data list (only the tables). 

 

According to vids and documentation I have found, they should appear in the list. 

I have tried refresh, restart the app and all that.

 

Thanx

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Dual Super User III
Dual Super User III

Is your SQL connector using your account to connect to the database or a service account?  If it is a service account did you make sure to give that user access to the Views you created?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Its a service account. 

 

It has access to all tables, but I could not find any way to give access on a view, so I guessed it inherit from the table. I will start look for access control on the view, but please advise how to give access. I use Microsoft SQL Server Management Studio. 

 

And thanks for quick feedback on the issue. 🙂

View solution in original post

6 REPLIES 6
Dual Super User III
Dual Super User III

Is your SQL connector using your account to connect to the database or a service account?  If it is a service account did you make sure to give that user access to the Views you created?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Its a service account. 

 

It has access to all tables, but I could not find any way to give access on a view, so I guessed it inherit from the table. I will start look for access control on the view, but please advise how to give access. I use Microsoft SQL Server Management Studio. 

 

And thanks for quick feedback on the issue. 🙂

View solution in original post

Community Support
Community Support

Hi @TurboTape 

 

Do you try to remove the connection and then add it again?

If there is exactly the view in the data source, could you please try to search it by input the view's name to test?

viewname.PNG

 

More information:

add-data-connection

https://powerapps.microsoft.com/en-us/blog/using-sql-server-views-in-powerapps/

 

Best Regards.

Yumia

Hi @v-yuxima-msft I tried to remove and add the connection with the same result. 

 

I tried a search for the view and add it manually, but it will not find it. 

 

As @Pstork1 suggested I should check the permissions. I have granted permission to create view (the only view permission I found), but still nothing. It feels like a permission thing, but have a hard time to find out how. 

 

 

TurboTape

 

 

Hi @TurboTape 

 

Do you solve your issue?

 

Best Regards.

Yumia

Yes @v-yuxima-msft . I finally figure out how to give access to my service account to show the views.

 

All good 🙂

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,243)