This week's blog post on solving business problems with Power Query is a guest post by Alex Jankowski Does your business or work group have manual tasks that are repeated regularly, such as data re-entry, copy/paste functions, sending the same old email,
In this post we will explore how to make the Sample Binary file path dynamic when combining files using the new Combine Binaries experience in Excel and Power BI Desktop. Sample Files If you'd like some sample data files to
If you've wanted to use Power Query to combine Excel files with a single click - like you could for TXT and CSV files - the feature is finally here*. The Combine Binaries feature has been re-written (as I discussed
One of the updates in the latest Excel 2016 Insider preview build is a new Combine Binaries experience for Power Query. This is both good and bad, and in this post we'll take a detailed look at both sides before
The November 2016 update is now out and it finally brings a way to view the Power Query dependencies viewer. While it’s been out in Power BI Desktop for a while, (as Matt posted about a while ago,) this is
More and more I’m seeing examples where people are trying to extract data from a mixed column. In other words, they have two data types in a single column, but need to find a way to extract one from the
In this post I’m going to explore the options for Visual Interactions in Power BI … in other words, I’m going to explore the options to control what happens to other visuals when you select one in Power BI. Visual
One of the most important questions we have when publishing our data models and Power BI reports is Can users see my raw data? The answer to this should virtually always be no unless you’ve explicitly stated you want this
This week I was playing around with MailChimp and Power BI. If you’re not familiar with MailChimp, it’s the service that we use to send out our Monthly-ish newsletter. I thought I’d show how incredibly easy it is to get
For those coming from the Excel 2013 world, you’ll surely want to create filters using the Power BI Slicers. After all, you know that Slicers and Timelines are two of the sexiest filters we have for controlling filter context in
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
