Get Dynamically Power BI Data & Send It by Email Using Power Automate – No License Needed!

Learn Power Platform faster at Pragmatic Works with this special discount!
Click here https://prag.works/PWT-affiliate-Vico...
Or use our Promo Code (VicoPWTODL)

Did you know you can extract data dynamically from a Power BI dataset and send it via email using Power Automate—without needing a premium license? In this tutorial, I'll show you exactly how to achieve this step by step.

Many users struggle with Power BI data automation because Microsoft often requires a premium license for scheduled reports or API access. However, in this video, I’ll walk you through a workaround that allows you to pull Power BI data dynamically and email it to stakeholders without paying for a Power Automate premium or Power BI Pro subscription.

We’ll use Power Automate Cloud, the Power BI REST API, and simple actions to collect data, format it properly, and send it to an email list automatically. This is perfect for automating report updates, sending summaries, or distributing insights from Power BI dashboards efficiently.

By the end of this tutorial, you'll have a working automation that fetches live Power BI data and sends it via email without requiring extra licensing costs. If you find this helpful, don't forget to like, comment, and subscribe for more Power Automate and Power BI tutorials! 🚀

00:00 Understanding what we need to get Dataset at Power BI Service
01:00 Creating a blank flow in power automate cloud to get Data from Power BI Connector
03:05 Creating DAX query to get dynamically data from power bi dataset dynamiccali step by step how to
05:30 delving deeper into dax queries in dax query view
07:22 Making the query dynamic to get the data from exatcly current month
09:11 Creating a table with more columns and data and sending in HTML table through email
15:27 My flow fails , checking what is wrong , fixing it and running .
----
🎲 Consulting and Partnerships - Contact me
contato@vicotreinamentos.com.br

📚 FREE study group
Telegram: https://vicotreinamentos.com.br/Teleg...

🔽 Connect with me
Instagram:   / ronanvico  
LinkedIn:   / ronan-vico  


💵 Support the channel by checking out our partners:
-Master Power Platform with exclusive discounts at Pragmatic Works: https://prag.works/PWT-affiliate-Vico
-Reliable and affordable VPS hosting: https://www.hostg.xyz/SHHTG
-Level up your skills with courses from DataCamp: https://datacamp.pxf.io/oqjkGn

🙌 HELP THE CHANNEL!
Press the THANKS button in my Videos.
Become a member of the channel, buy us a coffee☕ per month!
Share the channel!

📹 Fala português? meu canal Brasileiro!
   / ronanvico