Articles filed in category 'Power Query'

Powering Up Power BI: 7 Seamless Integrations with the Power Platform

By: John P. White

Last updated: Wednesday, October 8, 2025

Published in: CODE Focus Magazine: 2023 - Vol. 20 - Issue 1 - Power Platform

John P. White surveys seven seamless integrations between Power BI and the Power Platform that extend analytics into action. He covers how to automate dataset refreshes (scheduled or event-driven with Power Automate), achieve real-time reporting via Dataverse DirectQuery, enable writeback through the Power Apps visual, push live form results with Forms, alert and automate responses from dashboard tiles, and implement data-driven subscriptions through Flow. White highlights trade-offs (licensing, latency, DirectQuery limitations) and practical steps to implement each pattern, underscoring how these integrations turn insights into timely, cross-platform actions.

• Power BI
• Power Query

Power Query: Excel’s Hidden Weapon

By: Helen Wall

Last updated: Wednesday, August 31, 2022

Published in: CODE Magazine: 2020 - July/August

Helen talks about how to use Power Query, a tool that's part of Excel and Power BI that enables you to automate the ETL process of bringing data into Excel. Learn to create an elegant ETL process in Power Query to first bring in the data, then later refresh it with a single button

• Business Intelligence
• Data
• Data Science
• Data Visualization
• Data Warehousing
• Database
• Excel
• Power Query
• Tableau