Quick note to the Power BI developers looking to up their DAX game… I’ll be presenting a new session – Power BI Time-Intelligence: Beyond the Basics – to the following user groups… Baltimore SQL Server Users Group April 20, 2020 | Details Atlanta BI SQL Server Users Group May 4, 2020 | Details …if you […]
Category: Uncategorized
Earlier this week, a client came to me with a DAX error that I’d not seen before… Query (12, 4) Calculation error in measure <insert measure name>: The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column. After reviewing their code and […]
This is a question that has come up a few times over the past few months from several clients and so I figured it’d make a good quick blog post that can easily be pointed at to save time. I encourage you to make it to the end of this short post to find out […]
Categories
IDERA ACE – Class of 2020!
Just a few weeks ago, I was accepted into the IDERA ACE program class of 2020! Oh, never heard of it? Well, let me clue you in… IDERA ACEs are active community members who have shown a passion for helping the community and sharing their knowledge. Members are selected annually and are up-and-coming data professionals […]
This blog has been very silent over the past few months as all of my attention and free time was spent working with a small startup focused on delivering a commercial solution based on Power BI. I’ll probably share more details down the road, but suffice it to say, it was an amazing experience and […]
Quick post today showing how to programmatically deploy a Power BI report to an PBI On-Premise Report Server. Over the past few years, I’ve had the pleasure of helping a client build a business-user-driven fully automated analytics solution involving SQL Server, Tabular, and now Power BI. The solution starts with a business analyst logging into […]
In the previous blog post we walked through how to implement the As Partition Processing (open-source) solution using Azure Functions which generated some good questions and discussions. As a result, I’ve decided to take this another step and show you how to implement this solution using the Visual Studio Azure Function project type and modify […]
Last year, Christian Wade released an open source solution to automate partition management and tabular model processing. As someone who’s spent a lot of time setting up similar solutions for clients over the years, I can assure you this is a great contribution to the community and will save you and/or your clients a ton […]
Ever looked at a Power BI report visual and wondered what the logic was behind a calculation? In most cases, your options are limited to… asking the report author checking the report documentation checking the data dictionary …all of which… assuming they even exist! …severely disrupt the analytical workflow. In this post, we’ll see a […]
Of all the new features and capabilities currently available with Azure Analysis Services, dynamic scaling up/down and in/out are my 2 favorite. Scaling Up refers to adding more (CPU and/or memory) resources Scaling Out refers to adding more servers Together these features allow you to adjust resources to match changes in workload with only a […]
byoBI.com 