Skip to main content

Notifications

Community site session details

Community site session details

Session Id : h7d0Oz6YeFhBcrW/TyOpQC
Power Automate - Building Flows
Answered

Power bi dashboard automation

Like (0) ShareShare
ReportReport
Posted on 21 Dec 2021 07:15:06 by 30

is it possible to get data from power bi dashboard with power automate how would i do that 

  • PADUser123 Profile Picture
    30 on 24 Dec 2021 at 06:57:51
    Re: Power bi dashboard automation

    Thank you. it worked

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on 24 Dec 2021 at 05:42:20
    Re: Power bi dashboard automation

    Hi @PADUser123,

    Power Query can create POST requests to a web service, thereby passing values in the body of the call to the web service. This allows to export the data from Power BI. With Flow, it is very easy to setup a web service: Just create a Flow whose trigger is a “When a HTTP request is received” (no further inputs in that step) and add a “Compose”-action with the Body-element in it. Then save the Flow and copy the generated URL:

    vqiaqimsft_0-1640324013728.jpeg

     

    Or you could search for the Export to File for Power BI Reports action and go to Power BI service, and open the report we need to export. On the page you need exported you need to copy the last part of the URL, paste it to  the "Pages pageName - 1" section.

    Next, search for "Send an email v2", click within "Attachment Content", select "File Content" from among the dynamic content to attach your exported Power BI report.

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

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,645 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard
Loading started
Loading complete