MS BI fans, please join us online for the next Atlanta MS BI and Power BI Group meeting on Monday, May 4th, at 6:30 PM. Bill Anton will show you how to effectively apply time intelligence to your Power BI data models. For more details, visit our group page and don't forget to RSVP (fill in the RSVP survey if you're planning to attend). Presentation: Power BI…
Read article
A recent ask from an airline company was to perform sentiment analysis on comments in surveys collected from their customers. Sentiment analysis is a machine learning task that requires natural language processing. In Power BI, we have at least two ways to approach this requirement: Cognitive Services and custom code, such as by using the Python Natural Language Toolkit (NLTK). This post compares the pros…
Read article
Question: How to put Power BI files under source control? Workaround: Power BI Desktop does not currently support source control and it doesn't have an Excel-like extensibility mechanism to let developers take from where Microsoft left off. However, thanks to the enhanced dataset metadata (currently in preview), you can implement a rudimentary source control policy while waiting for third parties to fill in the void…
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
