This week, to round off the year, we try something different. I wanted to throw a shout out to all the community heroes out there, who also help make the most of Microsoft Fabric, through the use of Microsoft Power Platform (and vice versa).

Also, I wanted to highlight some of their contributions, and hopefully give you all a list of resources to peruse.

First thing first. Huge shout out to some of the community & Microsoft titans mentioned in this post, in no particular order: Laura Graham-Brown, Scott Sewell, Kristian Bubalo, Pat Mahoney, Jason Davidson, Chris Webb & Tim Weinzapfel.

Now without further ado…

Power Automate

• Detect Capacity Overloaders and automatically contact them: Track Power BI Capacity overloaders with Power Automate – PBI Guy (pbi-guy.com)
• Pause, Resume and Scale Fabric Capacities from Power Automate: Pause, Resume, and/or Resize Your Fabric F SKU Capacity With a Flow (youtube.com)
• Trigger Fabric Dataflows and Notebooks from Power Automate: Trigger Fabric Notebook or Dataflows With Power Automate (youtube.com)
• Save a file to OneLake w. Power Automate: Power Automate – Save a File to OneLake Lakehouse – Hat Full of Data
• Trigger Data Pipelines from Power Automate: Trigger Microsoft Fabric Data Pipeline using Power Automate – Hat Full of Data
• Create Workspaces with Power Automate: Power Automate – Create the Power BI Workspace – Hat Full of Data
• Data Driven notifications on Semantic Models: Data Driven Alerts on any data point in Power BI / Fabric Semantic Models with Power Automate – Downhill Data (downhill-data.com)
• Refresh Power BI/Fabric Semantic Models with Power Automate: Using Power Automate to Refresh Power BI Datasets (youtube.com)
• Send Text Messages and other actions on Data Activator Triggers: Send Data Driven notifications by SMS/Teams/Slack with Data Activator and Power Automate on real time eventstreams in Microsoft Fabric | by Jon Vöge | Medium
• Empower Metrics in Power BI w. Power Automate: Mini-Course Pt2 – Use Power BI Metrics + Power Automate to Trigger Email & Teams KPI Warning Alerts (youtube.com)
• Customized Email/PowerPoint subscriptions: Case Study – Use Power Automate to Email Fully Customised PowerPoint Outputs of Power BI Reports (youtube.com)
• Send data to Fabric from Power Automate via Eventstreams: Send data from Power Automate to Fabric using Eventstreams

Power Apps

• Write-back to Fabric with Power Apps & Power Automate: Live Data Write-Back to Fabric Data Warehouse from Power BI w. Power Apps and Power Automate – Downhill Data (downhill-data.com)
• Using Power Apps to Trigger Stored Procedures in Fabric: Combining Power Apps & Stored Procedures in Fabric Data Warehouse – Downhill Data (downhill-data.com)
• Maintaining RLS Tables in Fabric from Power Apps: Microsoft Fabric Write-Back Revisited: Maintaining RLS tables with Power Apps & Stored Procedures – Downhill Data (downhill-data.com)
• Trigger Power Apps formulas by selecting data points in Power BI: Auto-Trigger OnSelect Button Actions in Power Apps when selecting data points in Power BI – Downhill Data (downhill-data.com)
• Writeback from POWER POINT with Power Apps: Let Power Point users write data directly to your database w. Power BI & Power Apps – Downhill Data (downhill-data.com)

Power Pages

• Share Power BI Reports with externals using Power Pages: Share Power BI Reports with External Users using Power Pages and Power BI Embedded – Downhill Data (downhill-data.com)

Dataverse

• Accessing data from OneLake/Fabric in Dataverse: 4 ways to access data from Microsoft Fabric OneLake in Dataverse / Power Platform solutions – Downhill Data (downhill-data.com)
• Accessing Dataverse data in Fabric/OneLake: 5 ways to get your Dataverse Data into Microsoft Fabric / OneLake – Downhill Data (downhill-data.com)
• Using Fabric Pipelines for Dataverse: Fabric Pipelines for Dataverse Part 1: Introduction (youtube.com)