Error to using Power Automate in Power BI desktop

[vinicius_ramos]

Hello, 

I try to use the Power Automate into Power BI to send a e-mail but doesn´t work, 

The error mensage is: The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: entity.'.

Anybody can help me?

Thanks a lot.  

[vinicius_ramos]

@datadmin-austin 

Thanks a lot.

[vinicius_ramos]

Hello, @datadmin-austin 

I have this flow, at On Power Bi button clicked :

{

    "kind": "ApiConnection",

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

    "inputs": {

        "schema": {

            "type": "object",

            "properties": {

                "rows": {

                    "type": "array",

                    "items": {

                        "type": "object",

                        "properties": {

                            "entity": {

                                "type": "object",

                                "properties": {

                                    "Power BI values": {

                                        "title": "Tabela do Power BI",

                                        "type": "array",

                                        "items": {

                                            "type": "object",

                                            "properties": {

                                                "EMAIL": {

                                                    "title": "Tabela do Power BI EMAIL",

                                                    "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-email-encoded": {

                "title": "User email",

                "type": "string",

                "format": "byte",

                "x-ms-dynamically-added": false

            }

        }

    },

    "metadata": {

        "operationMetadataId": "5111b358-6f68-43a0-8cac-28c622f1643a"

    }

}

this help us?

Thanks

[datadmin-austin · Accepted solution]

Hello @vinicius_ramos,

For Power Automate flows inside of Power BI, the flow can only be triggered by a button inside Power BI and data cannot be added to the email from in Power BI. https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-automate-visual?tabs=powerbi-desk...

If your goal is to just send an email that has static text - I have a flow that does this: 

The flow must be created from inside Power BI as stated in the link. Does this make sense?