Power Automate for Power BI: the measure doesn't appear in the dynamic content.

[mateusz_ta]

Hi, I have a dashboard with a measure. I want to export the measure result every day into an excel table together with the current date. The excel table has been created. It has 2 columns: Date and Measure.

I have added a new  Power Automate for Power BI to the report. And added the needed measure to the visual's data.

I edit the visual, choose "Update an Excel table from Power BI", click Continue. Then I delete the default trigger "On Power BI button clicked" since I don't want to run the workflow on click but according to a schedule.

Luckily, there is a trigger called "Recurrence". So I choose it and enter all the necessary data like frequency and time.

Then I add a new step to the workflow (Current time).

Next, I add the "Update a row" step to the workflow. There, I can choose the Excel File Location, Table Name. I choose the Key Column (Date) and the Key Value (Current time), I can also choose the dynamic content for the Date column (Current time) but I cannot choose the measure for the Measure column. The measure just doesn't appear in the "Dynamic content" window. 

What do I have to do to make the measure appear in the "Dynamic content" window so that I can choose it in the "Update a row" workflow step? 

[menphis21]

I have the same problem 

Guys help please
@amitchandak @lbendlin @Ritaf1983 @Greg_Deckler @Ahmedx 

[lbendlin]

Post the raw output of the "Power BI Button pressed" trigger step.

[menphis21]

Here it is. For me succeed to add it yesterday (you can see it in a picture)
But i am trying to enrish the process , like trying to add a graph, or send pdf report 
it desappears.
It appears on the options in the email subject .

Thanks for your help

[lbendlin]

No, I want to see the raw output of the trigger for the last run. Like this

[menphis21]

{

    "kind": "ApiConnection",

    "splitOn": "@triggerBody()['rows']",

    "inputs": {

        "schema": {

            "type": "object",

            "properties": {

                "rows": {

                    "type": "array",

                    "items": {

                        "type": "object",

                        "properties": {

                            "entity": {

                                "type": "object",

                                "properties": {

                                    "Power BI values": {

                                        "type": "array",

                                        "items": {

                                            "type": "object",

                                            "properties": {

                                                "BI Partner": {

                                                    "title": "Power BI data BI Partner",

                                                    "type": "string"

                                                },

                                                "BI Partner Email": {

                                                    "title": "Power BI data BI Partner Email",

                                                    "type": "string"

                                                },

                                                "_Balance Amount": {

                                                    "title": "Power BI data _Balance Amount",

                                                    "type": "number"

                                                },

                                                "Weighted average b": {

                                                    "title": "Power BI data Weighted average b",

                                                    "type": "number"

                                                },

                                                "Aging Page 1 v2": {

                                                    "title": "Power BI data Aging Page 1 v2",

                                                    "type": "string"

                                                }

                                            },

                                            "required": []

                                        }

                                    }

                                },

                                "required": [

                                    "Power BI values"

                                ]

                            }

                        },

                        "required": [

                            "entity"

                        ]

                    }

                }

            },

            "required": [

                "rows"

            ]

        },

        "host": {

            "connection": {

                "name": "@parameters('$connections')['shared_powerbi']['connectionId']"

            }

        },

        "operationId": "PowerBiButtonClicked",

        "parameters": {

            "inputsPowerBiData": "{}",

            "pbi_source": "powerAutomate"

        },

        "headersSchema": {

            "x-ms-user-name-encoded": {

                "title": "User name",

                "type": "string",

                "format": "byte",

                "x-ms-dynamically-added": false

            },

            "x-ms-user-timestamp": {

                "title": "Timestamp",

                "type": "string",

                "x-ms-dynamically-added": false

            },

            "x-ms-user-email-encoded": {

                "title": "User email",

                "type": "string",

                "format": "byte",

                "x-ms-dynamically-added": false

            }

        }

    },

    "metadata": {

        "operationMetadataId": "1f3b6598-b225-47fa-8a6f-32f546e80b38"

    }

}

I am using RLS in the power bi using principalusername() function

[menphis21]

I tried to delete it and create a new one, the code is more simple

{

    "kind": "apiconnection",

    "splitOn": "@triggerBody()['rows']",

    "inputs": {

        "schema": {

            "type": "object",

            "properties": {},

            "required": []

        },

        "headersSchema": {

            "x-ms-user-email-encoded": {

                "title": "User email",

                "type": "string",

                "format": "byte",

                "x-ms-dynamically-added": false

            }

        },

        "host": {

            "connection": {

                "name": "@parameters('$connections')['shared_powerbi']['connectionId']"

            }

        },

        "operationId": "PowerBiButtonClicked",

        "parameters": {

            "inputsPowerBiData": "{}",

            "pbi_source": "powerAutomate"

        }

    }

}

[lbendlin]

That's the step definition.  I am trying to see if there is any actual data coming through. Go to the run history, click on the date of the last run (no matter if succesful or not) and then click on the yellow step. Finally click on "Show raw outputs" 

[menphis21]

Here it is

But i delete the old one and tried to create a new one based the same thing
it just not appears but if you search it, it appears
so problem solved

but i have another problem, it doesnt stop sending email...

it supposed to be on the selection that i selected

yesterday it worked.

[MAwwad]

When you are updating an Excel table from Power BI, you need to ensure that the measure is being passed as a parameter to the Power Automate flow. This can be done by including the measure in the Power BI visual that you are using to trigger the flow.

In the Power BI report, make sure the visual that you are using to trigger the flow (e.g. a chart or a table) is based on the same dataset that contains the measure you want to export. Then, add the measure to the visual, and configure the visual to pass the measure value as a parameter to the flow.

[mateusz_ta]

The measure is used in the visual and I've added it to the dataset. Sending a screenshot of the place where I'm stuck.