PowerApps must also see SQL Azure Queries, not only Tables

[Migrated_User]

On making the connection, I only see Tables, not Queries. This cannot be workable as Tables usually have many IDs and IDs are meaningless, Connection to Queries is a must: same as Excel and Power BI.

Yahya shared this idea  ·  March 21, 2016  ·

[Migrated_User]

For that matter it should allow for the selection of SQL Views and Stored Procedures as well. I prefer not to provide access directly to the data tables, while PowerApps enforces quite the opposite.

[MRCL]

Yes, access to views would allow us to decide which rows are brought into the apps 5000 limit.

[Maxibus]

I would second the "need" for access to Views.

[stvcdms]

This is incredibly important for the current apps we would like to develop. 

[Josefehse]

This is a must have. It won't make sense to give access to a full table to users, most of the time. It is my first try with Azure SQL in PowerApps and it is quite disappointing that it is not there.

[dreeddri]

Very important

[pjmendes]

This is a very important need indeed!!

[Steelman70]

This is very important for any serious business application

[Prachi_2911]

This should definetly be there, accessing the stored procedure and views through SQL Azure connection will be super helpful.

[Merlin]

Queries would make PowerApps so much more powerfull