Power Automate loop

Like (1) Share

Report

Posted on 23 Mar 2025 01:15:52 by Mekist

Hello

How can I create a loop in Power Automate, filter it in Power BI and send an email?

Categories:

Business Process Flows

All responses (8)

Answers (0)

MS.Ragavendar 1,062 on 30 Mar 2025 at 14:49:12

Like (0)

Report

Power Automate loop

@Mekist,

Can you use Page Names instead of Page IDs, or create a manual Page ID mapping if possible?
Mekist 12 on 30 Mar 2025 at 11:48:00

Like (0)

Report

Power Automate loop

Hello @MS.Ragavendar

I have a problem because I count the page ID instead of the report ID

There are many pages in the report, where is the page ID written or can we write it and take it out?

Should text or ID be written here?
MS.Ragavendar 1,062 on 30 Mar 2025 at 05:39:59

Like (0)

Report
Power Automate loop

@Mekist,

The 401 Unauthorized error with "X-PowerBI-Error-Info": "GroupNotAccessible" indicates that Power Automate cannot access your Power BI workspace.

Few Queries

Power BI workspace access is granted?

Re-add the Power BI connection in Power Automate.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item
Mekist 12 on 29 Mar 2025 at 16:18:27

Like (0)

Report

Power Automate loop

@MS.Ragavendar Hello

I did the filtering, when I applied the Power Automate system it gave an error, how can I fix the error?

{

    "statusCode": 401,

    "headers": {

        "X-PowerBI-Error-Info": "GroupNotAccessible",

        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",

        "X-Frame-Options": "deny",

        "X-Content-Type-Options": "nosniff",

        "Access-Control-Expose-Headers": "RequestId,X-PowerBI-Error-Info",

        "RequestId": "ea3ea651-b633-4183-bcb6-057d2472689a",

        "x-ms-client-region": "europe",

        "x-ms-flavor": "Production",

        "X-Ms-Workflow-Resourcegroup-Name": "12F553A5690D49F689614B92F700CF11-DEFAULT12F553A5690D49F689614B92F700CF11-ENV",

        "x-ms-workflow-subscription-id": "4577412c-8a48-48ba-9f9d-7cb48b2e9744",

        "x-ms-environment-id": "default-12f553a5-690d-49f6-8961-4b92f700cf11",

        "x-ms-tenant-id": "12f553a5-690d-49f6-8961-4b92f700cf11",

        "x-ms-dlp-re": "-|-",

        "x-ms-dlp-gu": "-|-",

        "x-ms-dlp-ef": "-|-/-|-|-",

        "Timing-Allow-Origin": "*",

        "x-ms-apihub-cached-response": "false",

        "x-ms-apihub-obo": "false",

        "Date": "Sat, 29 Mar 2025 16:14:43 GMT",

        "Content-Length": "309",

        "Content-Type": "application/json"

    },

    "body": {

        "error": {

            "code": 401,

            "source": "default-12f553a5-690d-49f6-8961-4b92f700cf11.12.common.europe.azure-apihub.net",

            "clientRequestId": "9ee55ba5-027d-4003-b14a-905f5c38d71f",

            "message": "The response is not in a JSON format.",

            "innerError": "Cannot read server response."

        }

    }

}
Mekist 12 on 29 Mar 2025 at 12:34:05

Like (0)

Report

Power Automate loop

@MS.Ragavendar Thank you

The filter URL specified in the article does not appear for me,
I made a filter with FIM User selection but the URL does not change, how can I do this?
MS.Ragavendar 1,062 on 29 Mar 2025 at 09:07:51

Like (0)

Report

Power Automate loop

@Mekist,

Do you want to apply a filter to Power BI report (https://wisedatadecisions.com/2021/01/18/filter-email-power-bi-report-pages-using-power-automate-excel/)

like this?
Mekist 12 on 28 Mar 2025 at 20:07:16

Like (0)

Report

Power Automate loop

I want to filter the Power BI report by looping through Power autome and send an e-mail
lbendlin 7,761 Super User 2025 Season 1 on 24 Mar 2025 at 20:59:13

Like (0)

Report

Power Automate loop

Please provide a more detailed explanation of what you are trying to accomplish. What have you tried and where are you stuck?

Community site session details

Power Automate loop

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Power Automate loop

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates