I’m pulling data from GitHub Codeowners into a Power BI report. All was dandy locally, but refresh failed on the PBI service with this: This dataset includes a dynamic data source. Since dynamic dat
It quite common to lose track of what filters you currently have applied to a Power BI report. Also, there’s no out of the box way to clear them all. So, here’s how to do it. We’re going to add an i
When using Power BI Desktop you will see the “Data” tab on the left. When you create a new DirectQuery connection, the “Data” tab disappears. It wasn’t obvious to me that the “Data” tab disappeared
Starting with version 1.5 of the Power BI Custom Visuals SDK, we now have the ability to create “slicer” visuals, which are visuals that can filter data in other visuals on the same report. For the pu
As you can imagine, we have many Power BI internal test environments and all Microsofties get redirected to an internal pre-release version of Power BI so we can test the latest features and provide f
Here’s how to reference three.js in your Power BI Custom Visual project. I have not tested to see if three.js actually works on powerbi.com, but this is how to resolve reference issues. 1. Setup you
I’m working on a new visual that uses an open source JavaScript control that includes a CSS file. I was hoping I could just reference it in pbiviz.json, but that’s not possible because it only suppor
I was recently asked to help build a “Range Slider” Power BI Custom Visual that simply filters a report based on the slider value. Unfortunately “filtering” is not currently supported in the new Power
Here’s how to render either an SVG or a PNG from within a Power BI Custom Visual. For this post, I’m going to use the IoT Hub icon that can be found in the Microsoft Azure, Cloud and Enterprise Symbol
The Power BI team just released v1.2 of the Custom Visuals SDK. With this version you now need to reference d3 v3.5.5 yourself. d3 v4 does not work yet. I’m working with the team to get a v4 compat an
UPDATE: The Liquid Fill Gauge visual is now available to download from the Power BI Custom Visual Gallery! – In this series, we are creating a Power BI Custom Visual from an OSS d3 visualization I fou
UPDATE: The Liquid Fill Gauge visual is now available to download from the Power BI Custom Visual Gallery! – This is a continuation of my attempt at creating a Power BI Custom Visual from an OSS d3 vi
You might see this error message when trying to load the Power BI Custom Visual “Development Visual” “Can’t contact visual server. Please make sure the visual server is running and configured correct
The purpose of this post is to show you how to take an existing open source d3 visual and create a Power BI Custom Visual from it. I’ve been digging into the new Power BI Custom Visual SDK and just cr
I have removed the content of this post because the Power BI team created the following dev environment setup page: Power BI Documentation: Use developer tools to create custom visuals Jon
What do you do when you find a static table online that you want to quickly slice and dice? Enter Power BI. Here’s the resulting Power BI report…details on how I created it below… How this report was
[ Here’s a Power BI offering index with short and sweet descriptions. I’ll keep evolving this list as the service develops. For Consumers Desktop – Create Reports locally and push to cloud. Web – Crea
Azure provides a set of services that allow you to visualize IoT device data in real-time. The data pipeline is: IoT Device –> Azure IoT Hub –> Azure Stream Analytics –> Power BI. Follow alon
Power BI just enabled the ability to embed a report into any website without requiring the viewer to authenticate – it’s called “Publish to Web”. It’s really easy to get the embed code. Here’s how: Cr
It took me a few minutes to figure out how to get the Power Pivot Excel Add-in installed, so I figured I’d do a post to save you some time. Instead of a download it’s actually already installed when y