Export PowerBI data to Excel

(0) Share

Report

Posted on by Raphael33

Hello everyone,

I need to export data from PowerBI to excel with power automate.

I created the following flow, using the following query to extract the data from powerBI.

Yet I don't undestand, as my flow works but puts empty data in my excel file (see last picture below) :

Please someone could help me through this ?

Thanks !

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

Hi , @Raphael33
Can you check your output in your flow run history if this action return the correct array :

And how do you configure in your Apply to each and add a row in a table action?

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Raphael33 32 on at

Like (0)

Report
Copy link

Link copied!

Hey,

Here is the output of my query:

Concerning the Apply to each, it's parameter is the action PowerBI "Rows of the first table" and I apply it into the following Excel file. I don't understand why it returns a blank table in excel...

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

Hi , @Raphael33
In your first action, dose it get your right value here ?
And what is your raw Excel file first in your side ? Dose the Excel file contains data?

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Raphael33 32 on at

Like (0)

Report
Copy link

Link copied!

Yes it shows the good values in the output.
The Excel file is raw, I need to update it once a week with that flow.
The problem is that when I run the flow, it should fill the rows with the data. Instead, it fills blank rows.
Here is how my excel file looks like :

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

Hi , @Raphael33
Can you see blow this Excel file has data. As add a row in a table will add the row in the last row in your Excel file including your blank row.

And did you put the value in this action for the column?

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Raphael33 32 on at

Like (0)

Report
Copy link

Link copied!

Yes, I applied this in the "Apply to Each" :
All the steps seem to be correct ?

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

Hi , @Raphael33
I test it in my side , this is my Excel file :
This is my test result in my table:

This is my flow , do you add the value you need to add in the "Add a row in a table" action:
item()?['YourfieldName']
You can see it in here:

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Raphael33 32 on at

Like (0)

Report
Copy link

Link copied!

I looked for the "Columns" and "Value" inputs but I only have these fields :

Is there something I am missing ?

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

Hi, @Raphael33
Thanks for your quick response!
The [Column] and [Value] is just my header/Column Name in my Excel file:

So you just need to put the value you need to add in this two columns.
In your side , you need to put the :
item()?['S06_Retroactive_Stocks_Equation(CDC V------']

You can copy this field name in your flow run history:

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No