Problem: I have data contained in a SharePoint Online list that I want users to be able to modify by using an embedded Power App visualization. However, Lists aren't a Direct Query data source which renders the embedded Power App relatively useless after reconnecting it to the List. I've done this with good success with SQL data sources previously, but I don't have the ability to push this data back and forth to SQL.
Is there any (relatively) straight forward method to pipe data from Lists into a Direct Query data source? According to this: https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources, Power BI datasets are Direct Queryable, so I thought I would be able to connect the Power App to the Power BI dataset being produced, but it does not seem to be an option in Power Apps. I also tried creating a Dataverse table from the List but ran into other issues.
Otherwise, is there a method I may not be thinking of to do this? I basically have a single field that I want users to be able to modify in-report so that they can update projections that are being calculated from that field, but the Power App method described above is the only way I can come up with to do this. Of course they could go into the List, update the necessary fields, and manually refresh the report, but I was hoping for a cleaner, one-stop-shop type solution.
Thanks for any help.
