Have you ever set up a nice query to UnPivot other columns, only to find that the query data types change when you add new columns? This post will cover why values become text after unpivoting other columns. Background We’ve
This is the fifth and final installment of this post series, and will demonstrate the process for publishing and sharing Power BI Dashboards (as compared to Reports.) Key things we’ll explore here are the additional benefits of Power BI Dashboards
This is the fourth installment of this post series, and will demonstrate the process for publishing and sharing Power BI Reports. Key things we’ll look at here are how to publish the dashboard, keep it up to date, and share
In this post I’m going to continue the process of creating a Power BI dashboard built off the data I sourced from OneDrive for Business. This time I’m going to look specifically at creating Power BI Card Visuals. Series Table
Last week I grabbed some data from OneDrive for Business. This week I’m going to start the process of creating Power BI visuals to build a dashboard which will be hosted in the cloud. Series Table of Contents This is
It’s been a few weeks since I’ve posted a technical blog post, and I need to get back to it, so here goes. This is going to be a five part post on how to Get Data From OneDrive for Business, (using
Hey folks, I'm actually on vacation, so this post is going to be short. I just wanted to make sure you all are aware that there is a new Power Query update available. New features in the July 2016 Power
Yesterday, Microsoft released the June 2016 Power Query update. Even though there are only four items on the list of new features, some of them are quite impactful. What’s new in the June 2016 Power Query Update The four new
One of my favourite tricks to use on a dashboard is to show the Last Refreshed Date. This is important as it lets you know how stale your data is. I think it’s even more important with Power BI, as
This week’s post was inspired by a question in my Power Query help forum. The poster has a set up data, and needs to keep the most recent entry for each person from a list of data. Background I never
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
