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
After Tableau and SiSense, Keeping 'em Honest continues with Qlik. Now, after they sold the company and took a hit in the latest Gartner's quadrant, I didn't expect much of a completion from Qlik but every now and then I run into a customer considering Qlik and willing to share Qlik's feedback on how Qlik outshines Power BI in every possible way (can't share these…
Read article
SQL Server 2017 introduces the ability to scale out SSIS. The primary scenario is to enable customers to scale out their SSIS execution at the package level. Imagine a retail business that has about 300 packages to run at the end of the day to push transactional data/finance data from multiple stores to the centralized data warehouse for reporting. All the 300 packages need to…
Read article
Issue: You want to use the Power BI Excel Publisher but it doesn't load. You look at the Excel add-ins and you see that it's deactivated. You try to activate it and then you get an error. Solution: Copy the following Office PIA files to the add-in folder (C:\Program Files\Microsoft Power BI Publisher for Excel\bin). Microsoft.Office.Interop.SQLIS.12.0.nupkg OFFICE.dll Unfortunately, I don't know where these files are…
Read article
I'll present "Understanding Power BI Premium" at three public events in June. June 8th, Carolinas Power BI Group in Greensville, SC at 6 PM June 24th, SQL Saturday Chattanooga, TN at 1:15 PM June 26th, Atlanta MS BI and Power BI Group, Atlanta, GA at 6:30 PM My calendar has the details. Microsoft Power BI has enjoyed a lot of attention and success since it…
Read article
I'm working on architecting a financial planning solution powered by Analysis Services Multidimensional. One thing that might not be obvious is how Multidimensional selects the target of writeback allocation. In this case, planning will be done at Customer and Product level. With the default equal allocation when writing at the customer level, it might appear that writeback doesn't work correctly. You'd expect that only the…
Read article
MS BI fans, join me for the next must-attend Atlanta MS BI and Power BI Group meeting on May 22th at 6:30 PM. My esteemed friend, Stacey Jones from Microsoft will explain the predictive analytics capability of Cortana Analytics Suite. He'll demo a predictive analytics solution that was developed in a single day! It leverages Azure Machine Learning, Azure Data Factory, HDInsight, Spark, Power BI, and Intelligent…
Read article
I'm sure we've heard the announcements today about Power BI Premium. In fact, Power BI Premium is so important that Microsoft has positioned it as a new product under the Power BI marketing umbrella name instead of a new licensing model. Microsoft and industry experts covered the announcements well so I won't reiterate the obvious. You may wonder what these changes mean for you. Let's…
Read article
The May release of Power BI Desktop adds the ability to define DAX calculated measures when Power BI Desktop is connected live to a Tabular model or Power BI datasets. This is conceptually similar to defining MDX calculated members in Excel connected to a cube. The measure definitions are local to the Power BI Desktop model (the Tabular model is not modified). You can do…
Read article
Please make sure you register free and join Microsoft Business Forward online event (https://www.microsoft.com/en-us/dynamics365/business-forward) on May 3rd at 10 AM ET. Join Satya Nadella (CEO Microsoft), James Phillips (Corporate Vice President, Business Applications, Platform and Intelligence), Judson Althoff (Executive Vice President, Worldwide Commercial Business) for major announcements and details on the "new generation" of Power BI, Dynamics 365 applications, LinkedIn, and the Microsoft Cloud. This…
Read article
MS BI fans, join me for the next must-attend Atlanta MS BI and Power BI Group meeting on April 24th at 6:30 PM. Mike Bruce and Alex Higgins from Acuity Brands will share how they use Power BI to improve their development process. Acuity Brands will sponsor the event. And I'll demo the new Quick Measures Power BI measure. Presentation: Using Power BI to Track Software Development…
Read article
