A date dimension or table can be extremely important when working on a Power BI project, or BI projects in general for that mater. Here’s
Category: Power Query
Power Query – Controlling M Query Functions with User Driven Parameters
Have you ever had a user run a query against one of your largest tables only for them to immediately filter the results in Excel
Power Query to HDFS – Remote Name Could Not Be Resolved
I wanted to share a quick resolution I had to a problem with connecting Power Query to data stored in HDFS. Seems easy enough. Launch
Power BI for Office 365 Released
Today Microsoft has officially announced the release of Power BI for Office 365. You can read the Power BI teams post on the release here:
Final Day for Power BI Voting, Can I Have Your?
Today is the final day for the Power BI Contest voting and I could use your help to move on in the competition! Please take
Power BI Contest Entry Voting
You’ve watched my video (hopefully) now vote for it! In a previous post I wrote about my Power BI contest entry (Read more about it
Power BI Contest Entry
Today I submitted my Power BI contest entry and I’d love for you to take a look! Here’s a short description of entry and the
Using Power Query to Parse your Inbox
One of the nice new features that was added to Power Query with the latest update in December is the ability to connect to Microsoft
Thoughts on December 2013 Power Query Updates
Just in time for Christmas the Microsoft product teams responsible for Power BI have a slew of amazing updates. The list of updates can be
Introduction to Power Query Q&A
Thanks everyone for attending my free webinar on Introduction to Power Query on August, 27, 2013. If you were not able join for the live
Whitepaper: Building Self-Service BI Solutions with Power Query
Through Self-Service BI, business units can personalize Business Intelligence to their needs and solve problems at a much faster rate than any traditional BI solution.
Extracting Data From Multiple Files with Power Query
In this post I’d like to demonstrate another way Power Query can solve simple data extraction problems without much time or effort. If you’re still
Using Parameters in Power Query Extracts
Introduction By now you have likely heard a little about Power Query (formally known as Data Explorer). While you may have heard of the tool
Devin Knight 