How do I automate exporting PBI visual data to Excel for each slicer value

[NewbieToPBIA_1]

Hi,

I am new to Power Automate (as well as to Power BI but manage so far).  I would like to automate the flow of exporting the PBI visual data to Excel table (I just discovered it won't do it to .xlsm but would do it to .xlsx) for each slicer value for that visual.  So the flow needs to loop through the slicer and then export the visual's data.  I can find resources on how to loop through slicer and then export the report (in PDF or PPT) but not export the visual's data.

Additionally, one of the data in the visual is a column date and I have attempted converting it (currently in UTC) to Eastern Australian standard time.  Due to my inexperience using Power Automate and lack of familiarity with the syntax, my attempted flows always failed.

There are ample example on the internet that describes how to convert a date variable (have to initialise it first).  If I try to pass the dynamic content (being the PBI column name) inside the "dateFormatTime()" expression, it gives me error message (I think something like I am passing an object inside the expression instead of string).  Does that mean I need to convert the PBI date column first into string before I can use it inside the "dateFormatTime()" expression?

In the image below, I have tagged "+???" as the intermediate steps (which I don't know what it should be) that defines the loop and what associated with the looping.  I assume I need a table somewhere with only the values of the slicers I want the process to go through ("List rows present in a table") and an action that assigns each of this value to the slicer (which is a Power BI column)?

I need to pass the "Power BI data Month" column into the expression, but first converting it to "mmm-yyyy" format.

Please help me 😞

Thanks heaps

[lbendlin]

@NewbieToPBIA_1 Please keep in mind that the Power Automate visual in Power BI does not have access to any other visuals or slicers.  It solely depends on the fields that you assigned to the visual and their current filter context.

There are other ways to pull Power BI Dataset data into Excel (via DAX or MDX queries, for example). You may want to consider going that route instead.