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.
I'd like to create a PowerBI or PowerQuery interface that outputs a list created by a query and then allows users to select a subset of items, which are saved to new table -- or somewhere where they won't be overwritten. See simplified example below.
Would anyone have suggestions for the best way to do this? I'd prefer to use PowerBI because I could add search filters.
In Excel I can imagine these steps ...
I'd appreciate any suggestions!
Hi @meagain ,
Using the Power BI you may try and use the Power Automate visualization, that allows to create custom automations based on Power BI data.
Using this you can create/update a file or a list in sharepoint that saves returns the Query2 data.
Another option on Excel is using VBA.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
@MFelix wrote:Hi @meagain ,
Using the Power BI you may try and use the Power Automate visualization, that allows to create custom automations based on Power BI data.
Using this you can create/update a file or a list in sharepoint that saves returns the Query2 data.
So far I haven't had success connecting PowerBI to Power Automate.
Hi @meagain ,
Do you have a onedrive account? There is no need to connect to sharepoint this can be done in a series of connections.
Check out if the flow below makes what you need, if yes tyou only need to replicate this on the power automate viasualization.
https://flow.microsoft.com/en-us/galleries/public/templates/4db78650-9144-4150-ae1a-2001d58d2bf9/upd... (This uses excel online)
But there can be made adjustment with different flows.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsMiguel, thanks for the tip about Power Automate. I'll check it out.
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.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |