web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / HOW TO: Getting data o...
Power Automate
Answered

HOW TO: Getting data out of Power BI when the Alert trigger is insufficient

(0) ShareShare
ReportReport
Posted on by 131

Ok, so I'm embarrassed about the level of hack in this solution, but it solves a business problem and I thought others might be running into the same issue.


Currently, the only integration between MS Flow and Power BI is via the Alerts trigger. This is handy for certain use cases, but doesn't help when you need to trigger a business process based on a human decision. It also doesn't allow you to pass a complex data object out of Power BI to the MS Flow workflow.

 

A workaround for this is to create a measure in Power BI that assembles a JSON object containing the required data elements I need from the Power BI report, and expose the JSON object in a user-selectable visualization (e.g,. a single-celled Table).

 

The report user then configures the report to get the desired result, copies the resulting JSON object from the PBI measure, and pastes the JSON into a dedicated Microsoft Teams channel. I can then run an MS Flow using the Microsoft Teams 'new item in channel' event trigger to grab the JSON object and perform operations against it.

 

Hopefully, at some point in the future there will be other trigger options from Power BI, but this very hacky approach has allowed us to get some integration work moving in the short term while we wait for a better solution.

Categories:
  • Verified answer
    v-zhos-msft Profile Picture
    Microsoft Employee on at

    Hi @StevenWade ,

    Thanks for your feedback.

    I think there will be more triggers and action about Power BI in the future.

    Anyway, if you have any good idea, you can submit the idea to Flow Ideas Forum:

    https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

     

    Best Regards,

    Community Support Team _ Zhongys

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • Verified answer
    StevenWade Profile Picture
    131 on at

    Thanks for the message. The approach outlined above is a workable solution in the interim if you need to get data out of Power BI.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 289

#2
11manish Profile Picture

11manish 288 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 125

Last 30 days Overall leaderboard