Forum Discussion
Strategy for implementing a menu-style list that captures and saves user selections.
Super UserHi 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.
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.
- Tried using the online version of Flow but I don't seem to have access to sharepoint via either of my MS accounts (O365 at home and Office 2016 at work).
- In PowerBI I tried using the Power Automate visual but that also tries to connect to a MS online account.
- Tried downloading and installing Power Automate desktop, but I can't figure out how to connect that app to a PowerBI or Excel query as a datasource.
- MFelix
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/update-an-excel-table-from-power-bi/ (This uses excel online)
But there can be made adjustment with different flows.