Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
"but I don't have the ability to push this data back and forth to SQL."
That's exactly what we have done in such a scenario. We have a SSIS package that frequently syncs the sharepoint list with a table in a SQL Server database. That table is then used as the Direct Query source for the report.
Not ideal - you still have the UX lag - but it's at least a step closer to completing the UX for the data write back cycle.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.