Two Hours to Change Your Business (Or Job. Or Life.)
Folks, today I want to share a source of personal pride – literally share it, and make sure YOU experience it
Category: Power Query
Power Query as a File Audit Tool
Today I am sharing how I use Power Query as a file audit tool to support a regular task I complete every week. The objective of this post is to create broader awareness of how great Power Query is to solve different types of problems, and to possibly get you thinking about other problems you have that could be solved with this tool.
List.Generate(): Create Tables from Thin Air in Power BI with M!
An article that includes a simple tutorial on how to create tables in Power BI with M written by the experts at P3 Adaptive.
Share and Refresh Power Query & PBI Get Data with Local Links
The concept of parameter tables in Power Query will be familiar to some and new to others. A parameter table is a way that you can “pass” values to Power Query (and also Power Pivot) and these values can then be used in your queries and/or the data model.
Power Query as an SSIS Alternative
One of the many things I love about Power Pivot and Power Query is that these tools have put BI into the hands of users
Consolidated Worksheets with Power Query
The more I use Power Query, the more I want to use Power Query – and of course the more I learn.
Power Query Super Charges the Internet
I spent time recently thinking about how Power Query has really opened up the data on the Internet and made it more accessible to us all.
Harness Power Query to Gain Competitive Analysis Insights from LinkedIn
Guest Post by Gil Raviv Intro: Many experts had proclaimed LongForm Journalism was headed towards extinction in the digital age. In fact it has found a new resurgence and a […]
Introducing Power Update!
An article on the introduction to Power Update by the experts at P3 Adaptive .
“I Modified an Existing Table in Power Query and Now it Won’t Refresh”– A Fix
It’s the same old story, I mashed and twisted some data through Power Query, pulled it through Power Pivot, spent hours creating calculated columns and measures, made a really nice Pivot Table with conditional formatting and all the bells and whistles.