Hi All I am in need of a CRUD editor for end users for a table in a fabric warehouse, the 1st thing that comes to mind (and co pilot actualy agreed :-D) was powerapps. However I cannot for the life of me get powerapp to connect and read a warehouse table. MS suggests to use dataverse, but when i connect that way i get "oops something went wrong try reloading".
I know there could still be another issue with the fact warehouse doesnt normally work with primary keys but I have found a potential solution for that.
Does anybody have any idea how to do this, or is powerapp not the right tool and do i need to use something else.
PS I tried to go directly to the sql connection, by creating an sql connector, but that only shows me a bunch of system stored procedures and again not my table
Thanks
Hans