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
During the "Building a data model to support 1 trillion rows of data and more with Microsoft Power BI Premium" presentation at the Business Applications Summit, Microsoft discussed the technical details of how the forthcoming "Aggregations" feature can help you implement fast summarized queries on top of huge datasets. Following incremental refresh and composite models, aggregations are the next "pro" feature that debuts in Power…
Read article
The July release of Power BI Desktop introduced composite models, which I wrote about in my blog "Power BI Composite Models: The Good, The Bad, The Ugly" Composite models make data acquisition much more flexible but also more complex. A Power BI table can now be configured in one of these storage modes: Import – The table caches the data. All Power BI features work.…
Read article
A good turnout last night for our Atlanta MS BI and Power BI Group July meeting. Some 60+ attended the meeting at the MTC office at Avalon. Kudos to Scott Fairbanks for the great presentation and CCG for sponsoring the meeting. Thanks to Microsoft for hosting us. We'll make the slides available shortly at http://atlantabi.pass.org/Resources.aspx.
Read article
If you haven't done so, watch the "Power BI and the Future for Modern and Enterprise BI" presentation from the Business Applications Summit (July 22-24) to find where Microsoft is bringing Power BI in the next few months. Power BI Service Scale and Adoption 19M data models hosted 58M monthly publish to web views 8M+ report and dashboard queries/hour Power BI a top 10 fastest…
Read article
The July 2018 preview of Power BI Desktop delivers two killer preview features that solidify the Power BI position as the best data modeling tool for personal BI on the market. First, Microsoft relaxes the Power BI relationship limitations by letting you create M:M joins between two tables. Second, you can now create a composite (hybrid) data model with different storage modes, such as from…
Read article
MS BI fans, join us for the next Atlanta MS BI and Power BI Group meeting on Monday, July 30th 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! Scott Fairbanks from CCG will show you how to create a tailored user experience with Power BI. Your…
Read article
Problem: A long standing limitation in Analysis Services Tabular and Power BI is the lack of default members, such as to default a Date dimension to the last date with data. Users find this annoying, especially for time calculations which require a date context and won't produce results until you add a date-related field to the report one way or other. To aggravate things even…
Read article
Problem: Consider the following Power BI report that shows the sum of ResellerSales[SalesAmount] by SalesTerritory[SalesTerritoryCountry], Employee[FullName], and ResellerSales[SalesOrderNumber]. This report is based on the following schema consisting of three tables. However, If there isn't a direct relationship between ResellerSales and Employee, the moment you add an unsummarized field from the second table on the many side, such as Employee[FullName] after adding SalesTerritoryCountry and ResellerSales[SalesOrderNumber), you'll…
Read article
Got awarded for Microsoft Most Valuable Professional (MVP) - Data Platform again. This will make my 15th consecutive year to be recognized by Microsoft for my expertise and contributions to the community! Learn more about the MVP program at https://mvp.microsoft.com/en-us/Overview.
Read article
A large company uses the SAP HANA ERP system. Users requires real-time access to transactional data. To avoid performance degradation, SLT replication (trigger-based change data capture) replicates data to another SAP HANA system that is used solely for reporting. The problem is that the more detailed the report gets and the more columns it has, the slower it gets and SAP HANA throws out of…
Read article
