Articles filed in category 'power query'

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

By: John P. White

Last updated: Friday, September 29, 2023

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

John presents seven examples of how to use Power BI with other tools in the Power Platform to use them better together. John's examples include refreshing data on a schedule or on change, creating real-time reports and dashboards, writing back data using Power Apps visual, displaying real-time survey results, alerting with dashboards, and creating data-driven subscriptions.

• 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