Tag: Power BI

Whenever I start a conference presentation, I lead with “Business Intelligence is not just reporting!”  This comes about as a call to get new Power BI users to look more broadly. If all you are doing with Power BI is replicating the Excel spreadsheets you already have, you are missing out on significant value. If […]

I was working with some bookmarks in a Power BI model earlier when I noticed that in some cases the Filter pane was expanded and in other cases, it was collapsed. I was intrigued so I started investigating. It seems when you save the bookmark, it now retains the open/close state of the Filter pane. […]

In an earlier post, I wrote about how to mine the OCR data from Office 365 document folders using Power BI. During the research for that post I discovered that the photo EXIF data is also available for analysis from Office 365. I’ll show you how to get to it in this post. What is […]

On occasion, useless solutions like this will be posted as they may not be directly useful in production, but they are educational in value and can lead to useful work. Oh goodness, what have you done? This post originally started as a joke at dinner with Adam Saxton of Guy in a Cube and Jason […]

If you need to do use small-multiple visualization in Power BI, see the easiest way to do it, using the Infographics Designer custom visual!

I’m so excited to see Optical Character Recognition (OCR) working natively now in Office 365! I got my start in government where we scanned a lot of documents. There was a lot of data locked away in those images but no easy way to mine it. OCR was explored as a possible solution, but it […]

Part 2 of this series explores the difficulty in determining whether your business intelligence content is using authentic data. To illustrate the point, let’s examine a recent Seattle Times article about the Measles outbreak happening in Washington. An Example The article in question, “Are measles a risk at your kid’s school? Explore vaccination-exemption data with […]

If you are creating Power BI content that you are embedding into a SharePoint Modern page, you know that the default Power BI theme colors don’t match SharePoint’s colors. Not to worry, we’ve got you covered.  Attached to this post and also cross-posted to the https://Community.PowerBI.com Theme Gallery is the Tumble Road SharePoint Modern theme. […]

What were you thinking? Do you remember exactly what you were thinking three months ago when you wrote that rather involved Power Query M statement? Me neither. So, why suffer when you can easily avoid the pain of code archaeology in Power BI? Piecing together a forgotten thought process around a particular problem can be […]

Power BI Accidental Tip This tip came about by accident. I was working on a new class exercise for https://sharepointna.com when I came across an easy way to sort your dataset columns alphabetically. While column search in the Query Editor makes this less necessary, it is very useful when working with DAX where you are […]