Unanswered

Export to multiple .csv files on OneDrive from Power BI based on several filters

(0) Share

Report

Posted on by xiloid

Hi!
Assume, I have a simple dataset with revenue by an entity by month.

I want a flow to take all the filtered (or unfiltered) combinations of entity and month, create a *.csv file by an entity by month, and dump them into a OneDrive folder.

i.e. if you have 2 entities: A & B

...and 2 months July & August,

I want the flow to create 4 .csv files:

1) EntityA_July.csv,

2) EntiyA_August.csv,
3) EntityB_July.csv,
4) and EntityB_August.csv

Any help is appreciated!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report

Re: Export to multiple .csv files on OneDrive from Power BI based on several filters

Hi @xiloid ,

I've made test for your reference:

1\I assume there is a dataset(I use an array type variable here for testing)

2\My flow

Expressions:

item()['Entity']

item()['Month']

union(body('Select'),body('Select'))

union(body('Select_2'),body('Select_2'))

@and(equals(item()['Entity'],items('Apply_to_each')['Entity']),equals(item()['Month'],items('Apply_to_each_2')['Month']))

items('Apply_to_each')['Entity']

items('Apply_to_each_2')['Month']

The Result:

Bof

Was this reply helpful? Yes No
Shaunbuckleyy12 79 on at

Like (0)

Report

Re: Export to multiple .csv files on OneDrive from Power BI based on several filters

Hi @V- ,

I also have a similar request where I have a dataset with Payroll Data.

I need to create upwards of 300 seperate csv. files filtering the data by each cost centre, save them down and also send an email to the relevent cost centre managers with the files attached.

I think I can use the solution you have above for the creating of the seperate files but your first screenshot of the solution is a little tricky to see, I was wondering if you could add in a clearer one if possible?

Would be much appreciated 🙂

Was this reply helpful? Yes No