cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

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
Highlighted
Dual Super User II
Dual Super User II

Re: SQL Views not showing in list

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

Highlighted
Advocate I
Advocate I

Re: SQL Views not showing in list

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
Highlighted
Dual Super User II
Dual Super User II

Re: SQL Views not showing in list

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

Highlighted
Advocate I
Advocate I

Re: SQL Views not showing in list

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

Highlighted
Community Support
Community Support

Re: SQL Views not showing in list

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

Highlighted
Advocate I
Advocate I

Re: SQL Views not showing in list

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

 

 

Highlighted
Community Support
Community Support

Re: SQL Views not showing in list

Hi @TurboTape 

 

Do you solve your issue?

 

Best Regards.

Yumia

Highlighted
Advocate I
Advocate I

Re: SQL Views not showing in list

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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,484)