What is with Excel Tables and the Data Model? Believe it or not, this is not the question I started with today, it was actually "which is faster; loading from CSV files or Excel?" My initial results actually brought up
Legacy Installers for Power Query and Power BI Desktop Let's be honest, one of the incredibly cool things about Power Query and Power BI Desktop is that they are updated monthly. We always get new features and bug fixes, but
Data Connectors for Power Query in Excel One of the things that makes Power Query so powerful is able to connect to almost any type of data source. So how come you find yourself asking, "Why is this connector not
A client contacted me today asking how to merge files with different column headers in Power Query. The issue she's facing is that some of the files in her folder have a column called "customer", where others have a column
How we reduce development lag when building queries in Power Query is a question that came up in my blog post at PowerPivotPro last week, even though that wasn't the main issue. I thought it might be a good idea
Today a user brought up something in the forums I've seen before; adding null to values returns null. Simply put, they wanted to add the values in two columns together, but didn't get the results they expected. The issue: Adding
As of June 1, 2017, there is a Power BI licensing change coming… The quick summary is that Power BI free is going to gain the ability to automate refresh via a personal gateway, but will lose the ability to
How you protect power queries is a question that will come up after you've built a solution that relies heavily on Power Query, especially if you're going to release it to other users. (This is a quick post, as I'm
I knew that the create Column From Examples feature had been released to Power BI Desktop, but it just showed up in my Excel 2016 build today. And man is it cool! A scenario for Create Column From Examples A
Last week I announced that we are working on a series of free 'DIY BI' e-Books. We've been hard at work on polishing it up, and I'm pleased to announce that the first DIY BI e-Book launches tomorrow! It will
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
