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
Tag: 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 Pivot as the Core to your Power BI Solution
I’ve noticed a recent trend with many presentations and articles on Power BI and Excel functionality. Many of these presentations show how quickly you can
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
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
Understanding Microsoft Self-Service BI Recording and Q&A
I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 2013. If you weren’t you can now
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 