Unanswered

Power Automate in Power BI not working

(0) Share

Report

Posted on by digitalPlay

I have a problem with power automate fetching data from power bi table, when I first started using the PA in PBI, it was working okay until I made a mistake of tinkering with it.
turned the concurrency control on, then off, now it's not working at all.

trigger will always return NULL even when there is a field in the visual, this is the error message I get.

has anybody had the same issue?

Categories:

General topics

All responses (6)

Answers (0)

Sort by

SanmeshG 1,956 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @digitalPlay ,

Looks like the expression is not returning a expected array. Is it possible for you to add a screenshot of the flow here?

Maybe the expression needs to be updated.

Thanks,
Sanmesh
digitalPlay 7 on at

Like
a
(0)

Report
Copy link

Link copied!

here is the sample flow and json in the trigger.

this is the json in the trigger:
{
    "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": {
                                                "Milestones": {
                                                    "title": "Power BI data Milestones",
                                                    "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
            }
        }
    },
    "metadata": {
        "operationMetadataId": "61a33c94-34cd-4e86-b9ad-d59ccf11a9e1"
    }
}
SanmeshG 1,956 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @digitalPlay

What is currently being retrieved looks like an object in the Power BI data , and it needs an array to iterate over it in apply to each. Try to get an array from the Power BI data else add it in compose and share the image of the resulting Compose here.
digitalPlay 7 on at

Like
a
(0)

Report
Copy link

Link copied!

this is when compose is used, tried initializing and setting variable but still nothing. I used the dynamic contents related to the supposed result but all resulted to null.
mlog Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

I have the same issue. Funny thing that my flow worked well several days ago. After two days, the same flow that worked before started to return "{}" in the output.
digitalPlay 7 on at

Like
a
(0)

Report
Copy link

Link copied!

I had another flow that was working prior to this, then thought to add another flow in BI but the second one started to give the null values even when it was basically the same flow. (Does power bi only allow one flow to work in it?)
Even when I create another flow in a totally separate power bi report, it's not working. disconnected and reconnected everything, still NULL everywhere 😞