cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StevenWade
Level: Powered On

Low barrier hack to get data out of PowerBI into an MS Flow workflow.

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.

 

My 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.

1 ACCEPTED SOLUTION

Accepted Solutions
StevenWade
Level: Powered On

Re: Low barrier hack to get data out of PowerBI into an MS Flow workflow.

2 REPLIES 2
Administrator
Administrator

Re: Low barrier hack to get data out of PowerBI into an MS Flow workflow.

Hi @StevenB ,

Is this a sharing?

Best Regards,

Cherry

 

StevenWade
Level: Powered On

Re: Low barrier hack to get data out of PowerBI into an MS Flow workflow.

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (6,737)