Change column order and name when emailing out CSV file from dataset

(0) Share

Report

Posted on by CU05121516-0

Hello All,

Power Automate newbie here so really appreciate your suggestions on this issue i'm having.

I created a simple flow to email a table of data from Power BI. Since the row count exceeds 1k I had to go through the PA online to make it work. The flow has the following steps:

1. Query against Power BI Dataset

2. Create CSV Table

3. Email that CSV

The issue I am having is - I went into Power BI and did the step where you record the table dax query in the analyzer to get that however the order it created it in is not the order that is in the table visual. Second is that the column headers are giving a DB like appearance like Table[Column] instead of Name for example.

My question is - what is the best way to change the order and names of the columns from the dataset query? I tried to go into the DAX code in step 1 and change it there but that keeps giving me errors that don't make any sense like a column has more than 1 value, etc. after I change the code but if I run it as-is it works just fine.

Any suggestions would be appreciated - thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Using a Data Select action in the flow to process the array produced by the query you can specify which columns you want, the order you want them in, and supply each column with a new name. Then use the output of the Data Select to create the CSV file.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
CU05121516-0 10 on at

Like (0)

Report

Thanks for the suggestion - I tried this but there is no way to link the Select to the dataset that I pull - at least from what I can tell. Do I need to use some code or something? When I hit Dynamic it just shows first few rows and if select that it just puts that in but not a column designation, etc. So, I tried to put in a Parse JSON before the select so it had something to grab onto which it worked from that aspect but when I went to Run it - it errors out saying my Schema on the Parse JSON is invalid. I put it in there by going to the output of the Query against the PBI Dataset step - since I had 1200 or so rows in there the code was quite long like 35k or something like that - is that why it said Invalid?

Any suggestions on how to use the Select or get my Schema to be 'valid'?

Was this reply helpful? Yes No
CU05121516-0 10 on at

Like (0)

Report

The other odd thing is that the Parse JSON only tells me it has an error in the steps for Invalid Schema - when I click into it to see where specifically it doesn't say anything about an error. There are no outputs, etc. So its hard to say where its failing. I read something about you need to specifically copy/paste it in a way otherwise it throws back errors - does that make any sense? Or any thoughts on why my job keeps failing?

Was this reply helpful? Yes No