Export to excel data from Power BI based on field parameter fields

(0) Share

Report

Posted on by KC-25101625-0

Hi All,

I have a use case where I want to export the data to excel.

In Power BI report, there is a matrix visual which is using field parameters (which has 7-8 dimensions - which will be dynamic based on the user selection) and 3-4 measures which are static.

1. I want to export to excel and every time create a new file with date and time --- format of the file: excelfilename-datetime
2. In this scenario, as I mentioned above # of fields and how many fields (dimensions) the user selects from field parameter list only those fields with measures (which are static) and those need to be exported to excel.

and also is it possible to save the excel file onto local machine of the user who runs the power automate flow instead of saving it on one drive or share point..

This is kind of urgent for me...

Thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

How are you planning to transfer the field parameters to the Power Automate visual in Power BI ? If you add them to the values well then you will probably either get all of them or none of them. Have you tried this out yet?

Was this reply helpful? Yes No
KC-25101625-0 40 on at

Like (0)

Report

Hi,

Yes, I already tried and I am getting all the original fields in the list when configuring the Power Automate step, but I am not getting field parameter field which is holding the # of fields (as I mentioned it will be dynamic when the user selects from the field parameter which has 7-8 dimensions it in ....based on the selection from the user and if the user selects 2-3 dimensions the same should be exported to excel with the static measures).

One additional point to mention here...whatever the selection made in the field parameter while exporting to excel it should come as a one field which will have # of rows (like if the user selects 2 dimensions in the excel will have 2 rows and if the users selects 2 dimensions from the field parameter same should be exported to excel as a one column).

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

You will have to assume that field parameters are incompatible with what you are trying to achieve.

Was this reply helpful? Yes No
KC-25101625-0 40 on at

Like (0)

Report

Ok so in that case what is the alternate solution where I need to store the values what I have selected from the field parameters...

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

I'll do some more tests but for the time being I am stating that there is no alternative involving Field Parameters. It will clearly work with hard coded column names.

(We haven't even discussed the scenario when you use field parameters for measures!!)

Was this reply helpful? Yes No
KC-25101625-0 40 on at

Like (0)

Report

Ok, thank you.

In terms of measures, I am using direct fields which are coming from the dataset itself. No field parameters for measures in this case.

Was this reply helpful? Yes No