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
SQL Saturday BI in Atlanta is around the corner. Prologika will deliver two sessions at this event on September 22nd: Bridge Analytics and Developer Worlds with Power BI and PowerApps by your humble correspondent, starting at 9 AM 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…
Read article
Data Analysis Expressions (DAX) is the expression language of Power BI, Power Pivot, and Analysis Services Tabular. It's very powerful but it's perceived as complex, requiring a steep learning curve. I'm excited to announce a new 2-day "Applied DAX with Power BI" workshop that I designed to help you become proficient with DAX. You'll learn practical skills that will help you tackle a wide range…
Read article
Scenario: DAX has its own share of idiosyncrasies that can humble both novice and experienced users. Consider a common example where a measure attempts to return sales for the last date in the Date table. What makes this common is that many real-life calculations require measures that evaluate as of the user-specified date (as of date), which is what MAX('Date'[Date]) returns. =CALCULATE(SUM(Sales[SalesAmount]), MAX(Date[CalendarYear]) ) As…
Read article
As Microsoft announced in the "Distribute insights across the organization with Microsoft Power BI" presentation (forward to the Nikhil Gaekwad part starting at the 32 min), they've been releasing the following set of features to improve the end user experience in Power BI Service: Home (not yet available) – Personalized landing page Personal bookmarks (not yet available) – End users can create their own bookmarks Persistent…
Read article
I have a few public events in September (all in Atlanta). Sep 11-12: 2-day Power BI open enrollment workshop Sep 20: "10 Ways to Empower Your BI Strategy with Power BI" presentation for DAMA Sep 22: "Bridge Analytics and Developer Worlds with Power BI and PowerApps" presentation for SQL Saturday – BI Sep 25: Meeting of Atlanta MS BI and Power BI Group at the…
Read article
Question: What's the maximum dataset size Power BI can support? Answer: As of now (Sep 1, 2018), the maximum dataset size that Power BI Pro can support is 1 GB. The maximum dataset size with Power BI Premium and Power BI Embedded is 10 GB but it depends on the SKU purchased. Power BI Premium Plan Power BI Embedded Plan Max Dataset Size and Memory P1…
Read article
A Power BI training or assessment won't be complete unless I get hammered on the Power BI sharing limitations. So far, I could only mumble something to the extent of "I agree that Power BI sharing sucks big time", look for the exit and suggest an unplanned break. Fortunately, it looks like quantitative accumulations from unhappy corporate customers have resulted in qualitative changes as Microsoft…
Read article
MS BI fans, join us for the next Atlanta MS BI and Power BI Group meeting on Monday, August 28th, Tuesday at 6:30 PM at the Microsoft office in Alpharetta (our regular venue room is being renovated). If you haven't been at the new MS office, prepare to be impressed! Mark Tabladillo, Ph.D, from Microsoft will show you how to advanced analytics with Power BI. Accelebrate will sponsor…
Read article
I rarely teach classes open to the public so take advantage of this exclusive opportunity to increase your data IQ! After course completion and by the end of the year, all course attendees will receive a free, one-hour, follow-up consultation with me on any Power BI or SQL Server related topic. Register today for these in-person and instructor-led training events as seating is limited. 2-Day…
Read article
As you've heard, data volumes are increasing and putting pressure on BI practitioners to do more with less within ever shrinking processing windows. I've provided some ETL best practices in various blogs, such as my "Is ETL (E)ating (T)hou (L)ive?" newsletter. A few additional considerations regarding data movement bottlenecks came from two recent projects targeting SQL Server. Slow Network If you're loading data from data…
Read article
