Power Automate - Power Bi Date to a SharePoint list

[hchqawa]

Need Help

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

[hchqawa]

Yes I am using Power Automate visual

[jennratten · Accepted solution]

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.

https://powerbi.microsoft.com/en-us/blog/announcing-the-new-power-automate-visual-for-power-bi-repor... 

[hchqawa]

Hi,

I am sending the data via power automate from Power Bi to a Sharepoint list.

Many thanks

Andrew

[jennratten]

Are you using a Power Automate visual in Power BI to do so?

[jennratten]

How are you sending the data from Power BI to Sharepoint?  Are you using Power Automate?