Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : aEa4C7wL6oQxpNsa2pRBgg
Power Platform Community / Forums / Power Automate - Building Flows / "On Power Bi button Cl...
Power Automate - Building Flows
Unanswered

"On Power Bi button Click" component fails to fetch data from Power BI

Like (1) ShareShare
ReportReport
Posted on 17 Mar 2025 07:03:07 by SG-21101158-0 8
Hello Everyone,
 
"On Power Bi button Click" component fails to fetch data from Power BI report.
Because of this, the flow is failing in subsequent steps.
And this flow was working fine for months and started failing all of a sudden. No recent changes made to the flow.
Please help me fix this.
 
Raw outputs of this button click component in power automate (Non-working scenario):
{
    "headers": {
        "Accept": "*/*",
        "Accept-Encoding": "gzip,deflate",
        "Accept-Language": "en-GB,en; q=0.9,en-US; q=0.8",
        "Expect": "100-continue",
        "Host": "prod-14.westeurope.logic.azure.com",
        "Max-Forwards": "10",
        "Referer": "https://app.powerbi.com/",
        "User-Agent": "Mozilla/5.0,(Windows NT 10.0; Win64; x64),AppleWebKit/537.36,(KHTML, like Gecko),Chrome/134.0.0.0,Safari/537.36,Edg/134.0.0.0",
        "Origin": "https://app.powerbi.com",
        "sec-ch-ua-platform": "\"Windows\"",
        "sec-ch-ua": "\"Chromium\";v=\"134\",\"Not:A-Brand\";v=\"24\",\"Microsoft Edge\";v=\"134\"",
        "sec-ch-ua-mobile": "?0",
        "sec-fetch-site": "cross-site",
        "sec-fetch-mode": "cors",
        "sec-fetch-dest": "empty",
        "priority": "u=1,i",
        "X-MS-APIM-Referrer": "https://europe-002.azure-apim.net/apim/logicflows/D7C829DCDD0F0F107D1616E8BD8F732A-D607713100F22D58/triggers/manual/run?api-version=2016-06-01",
        "x-ms-client-region": "europe",
        "x-ms-flavor": "Production",
        "x-ms-gateway-object-id": "",
        "X-MS-APIM-Referrer-Prefix": "https://europe-002.azure-apim.net/apim/logicflows/D7C829DCDD0F0F107D1616E8BD8F732A-D607713100F22D58",
        "X-MS-APIM-Callback": "https://europe-002.consent.azure-apim.net",
        "x-ms-user-id": "5d9bd89a-af0d-4f0c-90df-00325a31333d",
        "x-ms-user-name": "Srikar Gondesi - UAS Database Administrator",
        "x-ms-user-name-encoded": "U3Jpa2FyIEdvbmRlc2kgLSBVQVMgRGF0YWJhc2UgQWRtaW5pc3RyYXRvcg==",
        "x-ms-user-email": "sgondesi@uas.aero",
        "x-ms-user-email-encoded": "c2dvbmRlc2lAdWFzLmFlcm8=",
        "x-ms-user-timestamp": "2025-03-17T05:10:55.6019809Z",
        "X-Forwarded-For": "5.195.87.74, 20.86.93.35:20879",
        "X-ARR-LOG-ID": "cb7b87f2-45f9-48c5-88ee-6a043213ce8b",
        "CLIENT-IP": "20.86.93.35:20879",
        "DISGUISED-HOST": "prod-14.westeurope.logic.azure.com",
        "X-SITE-DEPLOYMENT-ID": "flowfe-prod-am-rp00-app-02",
        "WAS-DEFAULT-HOSTNAME": "flowfe-prod-am-rp00-app-02.flow-prod-am-rp00-ase-02.p.azurewebsites.net",
        "X-Forwarded-Proto": "https",
        "X-AppService-Proto": "https",
        "X-ARR-SSL": "2048|256|CN=Microsoft Azure RSA TLS Issuing CA 03, O=Microsoft Corporation, C=US|CN=westeurope.logic.azure.com, O=Microsoft Corporation, L=Redmond, S=WA, C=US",
        "X-Forwarded-TlsVersion": "1.2",
        "X-Original-URL": "/workflows/8febc9a1d8f74f8db692ee1d5c9a008e/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=80LlZx0fkbZRtvH8-Cna2o5b6tBcNH-4acyD0H8oKWQ",
        "X-WAWS-Unencoded-URL": "/workflows/8febc9a1d8f74f8db692ee1d5c9a008e/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=80LlZx0fkbZRtvH8-Cna2o5b6tBcNH-4acyD0H8oKWQ",
        "Content-Length": "24",
        "Content-Type": "application/json"
    },
    "body": {
        "entity": {}
    }
}
 
Raw outputs of this button click component in power automate (Working Scenario):
{
    "headers": {
        "Accept": "*/*",
        "Accept-Encoding": "gzip,deflate",
        "Accept-Language": "en-US,en; q=0.9",
        "Expect": "100-continue",
        "Host": "prod-14.westeurope.logic.azure.com",
        "Max-Forwards": "10",
        "Referer": "https://app.powerbi.com/",
        "User-Agent": "Mozilla/5.0,(Windows NT 10.0; Win64; x64),AppleWebKit/537.36,(KHTML, like Gecko),Chrome/134.0.0.0,Safari/537.36",
        "Origin": "https://app.powerbi.com",
        "sec-ch-ua-platform": "\"Windows\"",
        "sec-ch-ua": "\"Chromium\";v=\"134\",\"Not:A-Brand\";v=\"24\",\"Google Chrome\";v=\"134\"",
        "sec-ch-ua-mobile": "?0",
        "sec-fetch-site": "cross-site",
        "sec-fetch-mode": "cors",
        "sec-fetch-dest": "empty",
        "priority": "u=1,i",
        "X-MS-APIM-Referrer": "https://europe-002.azure-apim.net/apim/logicflows/D7C829DCDD0F0F107D1616E8BD8F732A-95578F3BEE00D213/triggers/manual/run?api-version=2016-06-01",
        "x-ms-client-region": "europe",
        "x-ms-flavor": "Production",
        "x-ms-gateway-object-id": "",
        "X-MS-APIM-Referrer-Prefix": "https://europe-002.azure-apim.net/apim/logicflows/D7C829DCDD0F0F107D1616E8BD8F732A-95578F3BEE00D213",
        "X-MS-APIM-Callback": "https://europe-002.consent.azure-apim.net",
        "x-ms-user-id": "eb979c33-63bf-43c6-b24e-42690341f68a",
        "x-ms-user-name": "Daniel Lightbody | UAS Quality Control Manager",
        "x-ms-user-name-encoded": "RGFuaWVsIExpZ2h0Ym9keSB8IFVBUyBRdWFsaXR5IENvbnRyb2wgTWFuYWdlcg==",
        "x-ms-user-email": "dlightbody@uas.aero",
        "x-ms-user-email-encoded": "ZGxpZ2h0Ym9keUB1YXMuYWVybw==",
        "x-ms-user-timestamp": "2025-03-14T01:30:12.0968776Z",
        "X-Forwarded-For": "97.101.223.99, 20.82.246.115:5254",
        "X-ARR-LOG-ID": "1f84b7e5-51bd-4ba8-add0-7031c298002e",
        "CLIENT-IP": "20.82.246.115:5254",
        "DISGUISED-HOST": "prod-14.westeurope.logic.azure.com",
        "X-SITE-DEPLOYMENT-ID": "flowfe-prod-am-rp00-app-02__7ba3",
        "WAS-DEFAULT-HOSTNAME": "flowfe-prod-am-rp00-app-02.flow-prod-am-rp00-ase-02.p.azurewebsites.net",
        "X-Forwarded-Proto": "https",
        "X-AppService-Proto": "https",
        "X-ARR-SSL": "2048|256|CN=Microsoft Azure RSA TLS Issuing CA 03, O=Microsoft Corporation, C=US|CN=westeurope.logic.azure.com, O=Microsoft Corporation, L=Redmond, S=WA, C=US",
        "X-Forwarded-TlsVersion": "1.2",
        "X-Original-URL": "/workflows/8febc9a1d8f74f8db692ee1d5c9a008e/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=80LlZx0fkbZRtvH8-Cna2o5b6tBcNH-4acyD0H8oKWQ",
        "X-WAWS-Unencoded-URL": "/workflows/8febc9a1d8f74f8db692ee1d5c9a008e/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=80LlZx0fkbZRtvH8-Cna2o5b6tBcNH-4acyD0H8oKWQ",
        "Content-Length": "7889",
        "Content-Type": "application/json"
    },
    "body": {
        "entity": {
            "Power BI values": [
                {
                    "Index": 1,
                    "Trip Number": "PEK-2504883",
                    "CallSign": "B8218",
                    "Sector": "VDPP-FMNN",
                    "Office": "PEK/ORG",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T03:00:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "03:00",
                    "ETD Date - Text": "3/14/2025",
                    "ETD Time ( Z )": "08:00",
                    "Service": "ATC FPL Filing",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 2,
                    "Trip Number": "HOU-2505055",
                    "CallSign": "HI985",
                    "Sector": "LEMD-EINN",
                    "Office": "HOU/BLU",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T04:30:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "04:30",
                    "ETD Date - Text": "3/14/2025",
                    "ETD Time ( Z )": "09:30",
                    "Service": "Operational Flight Package",
                    "serviceStatus": "Needs Follow-up",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 3,
                    "Trip Number": "HOU-2505055",
                    "CallSign": "HI985",
                    "Sector": "EINN-CYYT",
                    "Office": "HOU/BLU",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T04:30:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "04:30",
                    "ETD Date - Text": "3/14/2025",
                    "ETD Time ( Z )": "13:12",
                    "Service": "Operational Flight Package",
                    "serviceStatus": "Needs Follow-up",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 4,
                    "Trip Number": "HOU-2502619",
                    "CallSign": "N394WJ",
                    "Sector": "EGBB-LIML",
                    "Office": "HOU/BLU",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T06:30:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "06:30",
                    "ETD Date - Text": "3/14/2025",
                    "ETD Time ( Z )": "11:30",
                    "Service": "Operational Flight Package",
                    "serviceStatus": "Needs Follow-up",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 5,
                    "Trip Number": "PEK-2503408",
                    "CallSign": "CDG2438",
                    "Sector": "UAAA-ZWWW",
                    "Office": "PEK/ORG",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T06:40:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "06:40",
                    "ETD Date - Text": "3/14/2025",
                    "ETD Time ( Z )": "11:40",
                    "Service": "ATC FPL Filing",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 6,
                    "Trip Number": "DXB-2504306",
                    "CallSign": "VPCDL",
                    "Sector": "KMSP-KYIP",
                    "Office": "DXB/YLW",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T09:30:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "09:30",
                    "ETD Date - Text": "3/14/2025",
                    "ETD Time ( Z )": "14:30",
                    "Service": "Operational Flight Package",
                    "serviceStatus": "Needs Follow-up",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 7,
                    "Trip Number": "DXB-2504306",
                    "CallSign": "VPCDL",
                    "Sector": "KMSP-KYIP",
                    "Office": "DXB/YLW",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T09:30:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "09:30",
                    "ETD Date - Text": "3/14/2025",
                    "ETD Time ( Z )": "14:30",
                    "Service": "Cloned CFP",
                    "serviceStatus": "Needs Follow-up",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 8,
                    "Trip Number": "HOU-2505127",
                    "CallSign": "XACHB",
                    "Sector": "MMTO-KSAT",
                    "Office": "HOU/BLU",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T13:00:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "13:00",
                    "ETD Date - Text": "3/14/2025",
                    "ETD Time ( Z )": "18:00",
                    "Service": "Operational Flight Package",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 9,
                    "Trip Number": "HOU-2505127",
                    "CallSign": "XACHB",
                    "Sector": "KSAT-KEGE",
                    "Office": "HOU/BLU",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T13:00:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "13:00",
                    "ETD Date - Text": "3/14/2025",
                    "ETD Time ( Z )": "21:00",
                    "Service": "Operational Flight Package",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 10,
                    "Trip Number": "DXB-2504236",
                    "CallSign": "MJN524",
                    "Sector": "OOMS-UTTT",
                    "Office": "DXB/YLW",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T15:00:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "15:00",
                    "ETD Date - Text": "3/14/2025",
                    "ETD Time ( Z )": "20:15",
                    "Service": "Operational Flight Package",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 11,
                    "Trip Number": "DXB-2504236",
                    "CallSign": "MJN524",
                    "Sector": "UTTT-RKSI",
                    "Office": "DXB/YLW",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T15:00:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "15:00",
                    "ETD Date - Text": "3/15/2025",
                    "ETD Time ( Z )": "01:45",
                    "Service": "Operational Flight Package",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 12,
                    "Trip Number": "DXB-2505070",
                    "CallSign": "VTSDK",
                    "Sector": "VAPO-EDDM",
                    "Office": "DXB/YLW",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T16:00:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "16:00",
                    "ETD Date - Text": "3/14/2025",
                    "ETD Time ( Z )": "21:00",
                    "Service": "Operational Flight Package",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 13,
                    "Trip Number": "HOU-2504892",
                    "CallSign": "N288Z",
                    "Sector": "MYEH-EGGW",
                    "Office": "HOU/BLU",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T18:00:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "18:00",
                    "ETD Date - Text": "3/15/2025",
                    "ETD Time ( Z )": "13:00",
                    "Service": "Preliminary Flight Package",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 14,
                    "Trip Number": "HOU-2504853",
                    "CallSign": "N288Z",
                    "Sector": "EGGW-VHHH",
                    "Office": "HOU/BLU",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T18:00:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "18:00",
                    "ETD Date - Text": "3/15/2025",
                    "ETD Time ( Z )": "21:45",
                    "Service": "Preliminary Flight Package",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 15,
                    "Trip Number": "DXB-2504306",
                    "CallSign": "VPCDL",
                    "Sector": "KYIP-KLAX",
                    "Office": "DXB/YLW",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T19:00:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "19:00",
                    "ETD Date - Text": "3/15/2025",
                    "ETD Time ( Z )": "00:00",
                    "Service": "Cloned CFP",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 16,
                    "Trip Number": "DXB-2504306",
                    "CallSign": "VPCDL",
                    "Sector": "KYIP-KLAX",
                    "Office": "DXB/YLW",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T19:00:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "19:00",
                    "ETD Date - Text": "3/15/2025",
                    "ETD Time ( Z )": "00:00",
                    "Service": "Operational Flight Package",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 17,
                    "Trip Number": "HOU-2504566",
                    "CallSign": "N126HR",
                    "Sector": "KFLL-EINN",
                    "Office": "HOU/BLU",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T19:12:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "19:12",
                    "ETD Date - Text": "3/15/2025",
                    "ETD Time ( Z )": "00:12",
                    "Service": "Operational Flight Package",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 18,
                    "Trip Number": "DXB-2504489",
                    "CallSign": "CGTBD",
                    "Sector": "TQPF-KFXE",
                    "Office": "DXB/YLW",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T22:00:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "22:00",
                    "ETD Date - Text": "3/15/2025",
                    "ETD Time ( Z )": "15:00",
                    "Service": "Preliminary Flight Package",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 19,
                    "Trip Number": "PEK-2503395",
                    "CallSign": "CDG2438",
                    "Sector": "UAAA-ZWWW",
                    "Office": "PEK/ORG",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T23:40:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "23:40",
                    "ETD Date - Text": "3/15/2025",
                    "ETD Time ( Z )": "04:40",
                    "Service": "ATC FPL Filing",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                },
                {
                    "Index": 20,
                    "Trip Number": "HOU-2505127",
                    "CallSign": "XACHB",
                    "Sector": "KEGE-KDWH",
                    "Office": "HOU/BLU",
                    "Due Date": "2025-03-14T00:00:00.000Z",
                    "Due Time ( Z )": "1899-12-30T23:59:00.000Z",
                    "Due Date - Text": "3/14/2025",
                    "Due Time ( Z ) - Text": "23:59",
                    "ETD Date - Text": "3/15/2025",
                    "ETD Time ( Z )": "17:00",
                    "Service": "Preliminary Flight Package",
                    "serviceStatus": "Not Actioned",
                    "Measure_SelectedShift": 1
                }
            ]
        }
    }
}
 
 
Categories:
Business Process Flows

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans