Scenario: You want to overwrite the formatting of some field in a Power BI Visual, such as in the case of showing the field in one visual with decimals and then in another without decimals. Or, you might want to overwrite the default format when connected live to a semantic model. You search left and right, bing the Internet, and still no clue as to…
Read article
In my "Understanding Dates in Power BI Quick Measures" blog, I mentioned that having a Date table is a best practice but Quick Measures didn't support it. Fortunately, the February update of Power BI Desktop fixes this. Now you can mark a Data table as such, as you've been able to do in Excel Power Pivot since the beginning. Marking a date table accomplishes three…
Read article
Scenario: You have a concatenated field stored in a table. For example, a medical claim might have several denial reasons. Instead of representing this as a Many-to-Many relationship, you've decided to store this a comma-delimited field, such as to allow the user to see all codes on one row. However, users are asking to produce counts grouped by each reason code, such as this one:…
Read article
A while back I wrote about the ROI for BI and this blog happened to be one of my post popular blogs. I'm a big fan of a BI semantic model for the reasons I outlined in my "Why Semantic Layer" newsletter. Although written five years ago, these are still valid reasons and a semantic model plays a prominent role in every organizational BI solution.…
Read article
A week ago, I wrote that Power BI sharing improved by giving you the ability to include specific reports and dashboards in an app. Recall that that there are three ways to share Power BI content: workspaces, apps, and dashboard sharing. Only the last two lets you share content out of a workspace, such as by sharing with free users if the workspace is in…
Read article
MS BI fans, join us for the next Atlanta MS BI and Power BI Group meeting on January 29th at 6:30 PM. Julie Smith will hack sweet reports in Power BI. Innovative Architects will sponsor the meeting. And your humble correspondent will show you two new cool Power BI features: integration with PowerApps and Q&A in Power BI Desktop. For more details, visit our group page. Presentation:…
Read article
One Power BI aspect that I'm not crazy about is sharing. It's my experience that most organization could benefit from a simplified sharing where users or groups are added to a workspace with different roles and permissions, such as Content Manager, Browser, Administrator. This could have worked conceptually like SSRS security. At some point, we could have nested workspaces and custom roles, such as a…
Read article
Natural queries (aka Q&A) has been a prominent feature since Power BI Service existed. Wouldn't be nice to do the same in the Power BI Desktop? You can, but make sure to enable first Q&A from File, Options and Settings, Options ("Preview features") tab because it's currently a preview feature. Once you do this and restart Power BI Desktop, you should see "Ask A Question"…
Read article
UPDATE: Microsoft has added support for multi-valued parameters in the DAX Query Designer. Please read the discussion thread below for more info. You can use the approach discussed in this article if you need more control over the parameter handling, but the Microsoft-provided way should suffice for most cases and it's easier to implement. Déjà vu today with a twist. SSRS multivalue parameters in SSAS…
Read article
One of the Power BI most prominent strengths is that it's a part of the much broader Microsoft Data Platform that spans various on-premises and cloud offerings for data storage, processing, and analysis. After the integration with Visio, Power BI just took another leap forward with the introduction of the PowerApps custom visual. Use this visual to bridge the Data Analytics and Developer worlds. Now…
Read article
