Skip to articles

PROLOGIKA BLOG · IDEAS FROM THE FIELD

Making sense of data.
Sharing what we learn.

Practical perspectives on Microsoft Fabric, Power BI, semantic models, and the work of turning data into insight.

Explore the latest articles

Teo Lachev is MVP for 12 years!

Microsoft has been awarding Teo Lachev the prestigious Microsoft Most Valuable (MVP) award every year since 2004 for his expertise and contribution to the community.

Read article

Presenting at SQL Saturday BI Atlanta

Come and join me on Saturday, January 9 th at the first SQL Saturday BI edition in Atlanta. You'll learn about the exiting new BI changes coming to SQL Server 2016 and the Microsoft on-premises roadmap!

Read article

The Best Self-Service BI Tools of 2015

I came across this interesting PC Magazine article that just came up to compare 10 popular self-service BI tools. And the winner is? Power BI, of course, rubbing shoulders with Tableau for the Editor Choice award! The author, David Strom, did a great job reviewing the tools (this is not a trivial undertaking) but a few Power BI conclusions deserve clarifications: Cons: "Cloud version has…

Read article

Getting Rid Of Custom Visuals

Scenario: You might have imported a custom visual in Power BI Desktop, tested it, and decided not to use it. However, even if your reports don't use the visual anymore, Power BI will still prompt you if you want to enable custom visual with "This report contains a custom visual not provided by Microsoft…". This is a security warning to avoid malicious code because custom…

Read article

Implementing User Friendly Names in Tabular

Scenario: You'd want to have user-friendly field names in Tabular, Power Pivot, and Power BI Desktop, such as Claim Amount as opposed to database column names, such as ClaimAmount or Claim_Amount. Multidimensional has a feature that automatically delimits words with spaces when it detects a title case or underscore but Tabular lacks this feature. While you can rename fields in Tabular on field at the…

Read article

Microsoft Acquires Metanautix

If you've missed the announcement from a couple of weeks ago, Microsoft acquired Metanautix – a startup founded by ex-Google engineers who worked on BigQuery (aka Dremel). Technical details are scarce at point. In fact, the Metanautix website doesn't exist anymore but there are YouTube videos and slides, such as this one. A while back, I wrote about logical data warehouses, which come in different…

Read article

SSRS Treemap and Sunburst Charts

Years ago, I wrote a blog about how, with some code wizardry, you can create heat maps with Reporting Services. Moving to SSRS 2016, you don't have to do this anymore thanks to the new Treemap chart type! Speaking of new charts, SSRS also adds a Sunburst chart.  

Read article

Integrate SSRS 2016 Reports with Power BI

As I said in the "Microsoft Unveils BI Roadmap" blog, SSRS will play an important role of the on-premises BI portal. With this post, I'll start covering the new SSRS 2016 features. One of the Power BI features announced at the PASS Summit was the forthcoming integration between SSRS 2016 and Power BI that will allow users to pin SSRS report items to Power BI…

Read article

The One and Only Power BI Book

To me, Power BI is the most exciting milestone in the Microsoft BI journey since circa 2005, when Microsoft got serious about BI. Power BI changes the way you gain insights from data; it brings you a cloud-hosted, business intelligence and analytics platform that democratizes and opens BI to everyone. I'm happy to announce my latest (7th) book – Applied Microsoft Power BI. Currently, the…

Read article

Announcing Sparkline Visual

A sparkline is a miniature graph, typically drawn without axes or coordinates. Commonly used on dashboards, sparklines typically visualize trends over time, such as to show profit over the past several years. Although other Microsoft reporting tools, such as Excel and Reporting Services include sparkline elements, Power BI doesn't have one. That is until now. I contributed a "classic" sparkline custom visual to the Power…

Read article