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 ·
Using SQL Views in PowerApps is now available. See the blog to find out more: https://powerapps.microsoft.com/en-us/blog/using-sql-server-views-in-powerapps/
This is pretty much essential to be able to interact with any well designed database. Without it the ability to interact with many-to-many type relationships becomes ridiculously difficult unless all the data keeps within the 500 record limit.
I can't believe this is even a request. It seems this is such a clear need that I'm surprized it's not already implimented. This connection is useless without access to views and stored procedures.
@AllenB, welcome to the new world of Minimum Viable Products 🙂
I agree fella, I hope they hurry up with this, it should have been part of release 1.
Throwing out my two cents, we need views!
Views and Stored Procedures. Not only in Azure but in on Premise MSSQL and also for the Oracle connector
most of our analysis is using SQL views so we need PowerApps to support SQL on premise views otherwise PowerApps wont be of us to us. thanks
Seriously? Only tables?
Great to see that MS plans to make it possible to use views from SQL. Any idea about timing? When will this be available?