Forum Discussion
Power Automate - Power Bi Date to a SharePoint list
Can anyone advise if this is possible.
I have a report in Power Bi and I want to some of the values to be sent to a sharepoint list. I have successfully achieved this but the data that is going to the sharepoint site is the overall figures. I want to be able to filter the data for a period of time and send that data to the sharepoint list but it always wants to send the total figure unfiltered.
If it is possible, any advise on how to do it please?
Many thanks
Andrew
Great - then in the visual pane (in Power BI) for the Power Automate visual, add the fields for which you'd like the data to be filtered. After doing so, you can go to Power Automate and edit the flow and you will now see those fields as dynamic tokens that you can use in your flow. Here is a good overview.
5 Replies
How are you sending the data from Power BI to Sharepoint? Are you using Power Automate?
Hi,
I am sending the data via power automate from Power Bi to a Sharepoint list.
Many thanks
Andrew
Are you using a Power Automate visual in Power BI to do so?
Yes I am using Power Automate visual
Great - then in the visual pane (in Power BI) for the Power Automate visual, add the fields for which you'd like the data to be filtered. After doing so, you can go to Power Automate and edit the flow and you will now see those fields as dynamic tokens that you can use in your flow. Here is a good overview.
