Paradigm BI Posts | Planner Reporting Data Stage V2
Paradigm BI Posts - Paradigm BI and Active Business Intelligence Updates - We have a new version of the Planner Reporting data stage set-up scripts available,this is Data Stage V2.
Mysteries of filtering by Measure Value and a Calc Group Workaround
It is possible to filter a matrix by a measure, but may lead to unexpected results. See one such case and a possible workaround with a calculation group.
The ultimate hack to set column widths in a matrix
There is no configuration setting to set column widths in Power BI and existing hacks have downsides. This is the ultimate hack to set column widths in a matrix
Connect Excel to a Power BI Dataset in a Premium Workspace with a B2B User – Data Savvy
Power BI offers the ability for users who have access to a dataset in the Power BI service (PowerBI.com) to connect to the dataset using Excel. Normally, this feature is referred to as Analyze in E…
First look at Apache Superset from a PowerBI user perspective – Project Controls blog
Apache Superset is a very well known open source BI tool, I knew about it for the last couple of years, but was not thrilled by the idea of running a docker image on my laptop, recently though a ne…
Sam Fischer on LinkedIn: #PowerQuery #PowerBI | 19 comments
Did you know that you can easily zoom in and out in the #PowerQuery window? Zoom in: CTRL+SHIFT+= Zoom out: CTRL+SHIFT+- Credit to https://lnkd.in/dt-qUqYD... 19 comments on LinkedIn
Swap connection from Analysis Services to Power BI dataset
A while ago, I wrote a blog about migrating Analysis Services dataset to Power BI Premium. Back then there were not many options to do so, today there are many more like ALM toolkit. Though, the re…
Finding the lowest value and highlighting in DAX | Power BI - Guy in a Cube
Sometimes you want to highlight the lowest value in a Power BI visual. First you need to find it! Then you can highlight it. What if you want to ANIMATE it? Patrick shows you how to do just that! ALLSELECTED() article: https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/
Michael Kovalsky on LinkedIn: GitHub - m-kovalsky/Tabular: Useful code for tabular modeling and
Version 1.1 of the #exportreportobjects script has been released! With this version, the script will identify unused objects (measures/columns within your...
Power BI Report Server September 2021 Feature Summary
We’re excited to bring you a new version of Power BI Report Server this Fall! With the September 2021 update, we have a variety of new enhancements, including line charts improvements, new formatting options for buttons, small multiples new feature, and new Model View.
Security Group Support for Log Analytics Integration (Preview)
AD Security Group support is now available for Log Analytics for Premium workspaces. This allows Tenant administrators to control which Workspace admins can use the Log Analytics integration to log activities from their Power BI workspace.
After some time off from blogging, I'm finally back! During the last couple of months, I've been working on something a little bit different, so no, this time you won't see a huge post or some tutorial on how to do some fancy trick with a visual in Power BI. In this blog post, we are going to talk about Power BI Adoption! If you're not yet familiar with the topic, I highly recommend you to have a look at this documentation available on Microsoft Docs (everything I've done was based on this serie
Count Stints for Employees - DAX Challenge - Goodly
Recently while working on a consulting project, I came across a very interesting problem. It was interesting enough, that I am passing it on to you. Consider this Employee Data The data represents an employee role for each month, since the employee’s joining date. Each row means 1 employee assigned to a certain role [...]
What to Do When Calculation Groups Break Your Measures (PowerBI Tutorial) – business intelligist
Unfortunately, it does happen… You have just added a new calculation group/calculation item to your model and all of the sudden, some of the visuals on your report stop working. Usually, the main r…
Increasing DAX Filter Speed and Efficiency | Purple Frog Systems
To understand how a filter can affect performance, first we need to understand what a filter is. A filter is a temporary table that is created on demand, held in memory, and then used as a reference for the function being filtered. The rows of the temporary filter table are all DISTINCT. This is because […]
Chris Webb's BI Blog: Three New Power BI/Power Query Books Chris Webb's BI Blog
I decided to stop writing book reviews here on my blog a long time ago: it’s a lot of work to read a book and write a proper, detailed review and what’s more I don’t like the idea…
Batch conversion of headers and column values - Microsoft Power BI Community
Scenario: Suppose I have many columns which both column names and fields look untidy. I want to do some transformations for them in batches. For example, replace multiple spaces as single space and uppercase each first character of word so that the table would look neater. Sample data: Expected ...