cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
milo1234
Helper I
Helper I

Automatically update Outlook report within Power Bi

I have connected Outlook to Power BI however I want automatic changes to be made i.e. when a new email is received in Outlook, this is updated within Power BI. 

 

How do I do this please?

2 REPLIES 2
milo1234
Helper I
Helper I

@ImkeF Thank you. 

Are you able to show me the Power Automate flow please?

ImkeF
Super User II
Super User II

Hi @milo1234 ,
you can use Power Automate to trigger a dataset refresh when a new email is received. But the frequency is limited: 8 times per day with a pro license and 48 times with a premium license.

If you need to refresh more often, you could instead build a model in Direct Query mode and reference a SQL server or Dataverse for Teams. Use Power Automate to push the Outlook-data in there. For SQL-server you need a PA pro license, but Dataverse for Teams would work without.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors