PROLOGIKA BLOG · IDEAS FROM THE FIELD
Practical perspectives on Microsoft Fabric, Power BI, semantic models, and the work of turning data into insight.
Explore the latest articles
Take advantage of this exclusive opportunity to increase your data IQ from the comfort of your home wherever you are! Register today for my instructor-led digital training events and learn the Microsoft Power Platform consisting of Power BI, Power Apps, and Power Automate. 1-Day Power BI Dashboard in a Day (DIAD) Workshop Date: April 14, 2020 Time: 9:00 AM – 5:00 PM Eastern Time (GMT…
Read article
MS BI fans, the time has come for a virtual meeting. Please join us online for the next Atlanta MS BI and Power BI Group meeting on Monday, April 6th, at 6:30 PM. I'll show you how business analysts can apply AutoML in Power BI Premium to create predictive models. For more details, visit our group page and don't forget to RSVP (fill in the RSVP…
Read article
I helped an ISV a while back with their BI model design. They purchased a data transformation tool for $5,200/year because it's "simple to use" (the tool was designed for self-service data transformation tasks by business analysists) and "relatively inexpensive". The idea was to run the tool manually every time they have new data, import data from text files, transform, and output the data in…
Read article
I've seen various reports designed to track COVID-19. I personally like the Microsoft Bing tracker (https://www.bing.com/covid). Not only does the report track the current counts, but it also shows a trend over time. It even goes down to a county level (the trend is not available at that level)! And it's very fast. As good as it is, this is one report I hope I…
Read article
As it stands, Power Apps doesn't offer an easy way to get to the app source code. Yet, there are scenarios where this could be useful, including: Putting the app source under source control when the Power Apps version history is not enough. Currently, Power Apps doesn't integrate with source code repos, such as GitHub. Finding references to an item. For example, I've referenced a…
Read article
Power BI Service (powerbi.com) packs a graphical lineage view with the caveat that it only works within a workspace. As a Power BI admin, you may need a utility to inventory all Power BI artifacts published to all workspaces (including My Workspaces) in your Power BI tenant. Fortunately, the Admin - Groups GetGroupsAsAdmin can do the job in one call without any coding! Don't be…
Read article
In my previous post "Power BI Embedded, Service Principals, and SSAS", I discussed how you can integrate Power BI Embedded (App Owns Data) configured for service principal authentication with SSAS to pass the effective user identity. One important observation is that you can use this approach with both internal and external users. For internal users, the Power BI gateway (running under an account that has…
Read article
Null and zero typically have different semantics, where null indicates an unknown or missing value while zero is an explicit value. Sometimes, however, you want to show nulls as zeros. For example, an insurance company might want to show 0 claims instead of a blank value. By default, when a DAX filter doesn't find any rows, the formula returns null (BLANK in DAX). For example,…
Read article
Scenario: Management has requested an easy way to view a subset of strategic reports located in different Power BI workspaces. You can ask the users to mark reports and dashboards as favorites so they can access pertinent content in the Favorites menu, but you're looking for an easier configuration, such as to create a book of reports with a built-in navigation that organizes reports in…
Read article
Scenario: You plan to display a Power BI report on a monitor. You want the report to automatically cycle through report pages, showing each after a configurable time delay, like a photo slide show. Solution: There are at least two solutions to accomplish this: The Microsoft-supported way is to install the Power BI Mobile for Windows and use its presentation mode feature, which is shown…
Read article
