2021-12-07Comments Off on All Columns have Data Types in DAX, Or do they?
To say this another way. Not all columns have datatypes in DAX, specifically speaking to using dynamic ranking with an “Other” category. Let me explain. The Tabular model is comprised of tables with typed columns. This is a truth learned in one’s Tabular infancy. Whether the table is imported, calculated, [...]
Trolling… we should clear up the definition of this right off the bat. We aren’t talking about the type of trolling where we spend a bunch of time finding things on the Power BI Ideas site and say obnoxious things about them to elicit a response. We may say obnoxious [...]
We’ve been having an amazing amount of fun having conversations on our podcast “Explicit Measures”. Join us live on Tuesdays and Thursdays on YouTube or listen on Spotify or Apple Podcast. During our podcast this last week, we talked about which method is better when trying to learn all the [...]
Howdy, folks! This past weekend, I was a man on a mission. There were two pressing reasons for a new release of Business Ops: The authors of many popular External Tools released updates recently, so we needed to ship a new version of Business Ops with those updates includedLast week, [...]
Much thanks must go to both Ferry Bouwman and Rui Romano for inspiration and building off the work they have done already for the use cases for the Scanner API. Ferry created the initial Microsoft Flow to automate the request and pull of data, and design ideas were taken by [...]
Howdy folks! We have just published a bugfix release for Business Ops; Version 2.0.2 is now available for download. Please see the instructions below for details. Instructions If you have installed Business Ops 2.0 or 2.0.1, you should use the “Edit External Tools” menu to remove the External Tools you [...]
Where does the Power BI Mobile app fit within your report building plan? This topic is widely un-discussed within the Power BI community. Many blogs and tutorials focus mainly on developing Power BI reports for a desktop screen. More specifically, a report design that fits a wide screen monitor. However, [...]
2021-09-23Comments Off on Three New Time-Saving Scripts for Tabular Editor
Howdy folks! I just published three new scripts for Tabular Editor to the PowerBI.tips “TabularEditor-Scripts” repository on GitHub yesterday. So, I wanted to take a moment to explain what they do, and why you should have them in your Tabular Editor Scripts arsenal. Replace String Across All Power QueriesReplaces a [...]
2021-09-12Comments Off on Copy Power BI Desktop Server:Port Connection String to Clipboard
Howdy, folks! A few months ago, I was writing and running various PowerShell scripts to manipulate the connected data models in my Power BI Desktop files. During model development, I was constantly having to open DAX Studio to copy the Server:Port connection string, and thinking, “there’s got to be a [...]
This article follows from Episode 5 of the new Explicit Measures Podcast, a whole new way to talk about Power BI. If this article strikes you as relevant, subscribe to the podcast on Spotify, Apple, [...]
This is part 3 of 3 in a series designed to help Power BI users and enthusiasts. The first post focuses on identifying the dizzying array of skills that make up the Power BI ecosystem. [...]
One of the biggest improvements you can make to your life and career is embracing a learning mentality. If you are here, I assume one of your interest areas is Power BI. This post is [...]
There is a strong advantage to use all the Power Platform tools together, Power Apps, Power BI, and Power Automate. This article provides cases to use these applications together as a complete product. […]
Power BI Version Control is a free, fully packaged solution that lets users apply version control, local editing and manage PBIX or PBIT files. The solution is fully in the Power Platform and SharePoint environment. [...]
Power BI took the BI world by storm 5 years ago, there has been a release of the Power BI Desktop almost every single month. The infant that was Power BI has grown into a [...]
I was having a candid conversation with Phil Seamark from DAX.tips about Aggregation Tables. During that conversation, I was asking about patterns in using Aggregation tables. Within that 10 minute conversation I was blow away [...]
This article will focus on Power BI architecture within a data solution. This Power BI architecture describes how Power BI can slot in as a piece of this strategy. Next, it discusses different Roles and [...]
We just completed an amazing webinar from Parker Stevens over at https://bielite.com/ . In this webinar, Parker walks us through how to connect to the Power BI Admin APIs. The Admin API contains a wealth [...]
The Power BI Field Finder created by Stephanie Bruno was just updated. In this recent update the HTML viewer has been updated since the old custom visual has been deprecated. What is Field Finder? We [...]
