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
Power BI Desktop has a very useful feature that lets you create tables by manually entering the data. This could be useful in a variety of scenarios, such as entering some reference data, defining KPI goals, creating simple lookup tables, or prototyping some data. If you're familiar with creating tables in Power Pivot by copying and pasting tabular data, think of Enter Data as the…
Read article
Now that Power BI Desktop supports Row-level Security (RLS), modelers have a little predicament. On the desktop, the USERNAME() function returns the user's domain login (domain\login). However, when the model is deployed to powerbi.com, Username() returns the user principal name, which typically (but not always depending on how your AD is set up) is the user's email address. To simplify dynamic security based on the…
Read article
There is a lot of interest surrounding Power BI Embedded from organizations looking for cost-effective ways to embed customer-facing (external) reports in custom apps. And there will be even more interest now that Microsoft reduced the Power BI Embedded cost dramatically by switching from per-render to a session-based pricing model. The best way to get started with Power BI Embedded is with the Microsoft sample…
Read article
Are you looking for an agile self-service platform that doesn't require reporting and query skills to get basic analytics done without reliance on IT? Or, perhaps you've heard or evaluating Power BI but not sure where to start or how to take the most out of it? If so, this workshop is for you. A year ago Microsoft unveiled the new Power BI platform consisting of…
Read article
A year ago Microsoft unveiled the new Power BI platform consisting of the PowerBI.com cloud service, Power BI Desktop, and Power BI Mobile. Since then, Prologika has helped organizations of all sizes to plan and adopt Power BI. Packed with features, Power BI supports a dizzying variety of features and integration scenarios but it might be difficult to understand how Power BI fits in your data analytics ecosystem.…
Read article
Currently in preview, Microsoft Flow is a cloud service for creating automation flows without writing code, similar to Zapier's "zaps" and IFTTT's "recipes". How is this useful for BI? Let's consider an example. Power BI has recently introduced data-driven alerts in Power BI Service (previously alerts were supported on iPhone only). Currently, alerts can be created only on single-card and gauge dashboard tiles that are connected to…
Read article
Recently, Power BI charts introduced trend lines. However, they require numeric or date values on X-axis, which must have a continuous type. In fact, if you use a text field for the X-axis, a warning indicator will be displayed in the top left corner of the chart to warn you that non-numeric values are used. This requirement presents issues if the report is connected to…
Read article
Power BI is one-year old. it's hard to imagine that one year has passed but here we are. The momentum behind Power BI is huge both from development and customer perspectives. It's exiting to see a product that evolves so fast based on feedback from users. So, there will be many more birthdays. And for the nay sayers out there, no, Power BI is not…
Read article
MS BI fans, join me for the next Atlanta MS BI and Power BI Group meeting on July 25th at 6:30 PM. Shabnam Watson will teach you MDX fundamentals. Pyramid Analytics, our sponsor, will show us why they are Microsoft Power BI preferred vendor. And I'll demo the Power BI Publisher for Excel. Rate this meeting http://aka.ms/PUGSurvey, PUG ID: 104 Presentation: A SQL Developer’s Guide to MDX Basics…
Read article
Have you looked at your BI spend recently? Sometimes, I'm puzzled by the enormous spending in "this is how we've always done it" initiatives that probably could be replaced and done much more efficiently with modern technology and cloud computing. I had a recent conversation with a Chief Analytical Officer of one of the US largest financial organizations. They have outsourced hosting of their 5…
Read article
