Power BI

Microsoft Fabric has only been in preview for a week, and I’ve already written one post that covers data governance – do we really need another one already? I think we do. Over the week…

If you’ve read the Power BI adoption roadmap or attended any of the full-day training sessions I’ve been doing with MVP Melissa Coates[1], you know how important it is to manage setting…

The data internet this week is awash with news and information about Microsoft Fabric. My Introducing Microsoft Fabric post on Tuesday got just under ten thousand views in the first 24 hours, which…

On Friday June 9th, Data Ceili – Ireland’s biggest Microsoft data platform event  – returns to Trinity College in Dublin! Update 28 May 2023: Adding one more CAT session to the li…

Microsoft Power Platform admins can monitor certain types of security vulnerabilities using the static analysis tools and reports provided in the platform. Having an early and more holistic threat detection and the ability to apply preventative guardrails is crucial to enable frictionless productivity while minimizing cyber risk.

This post addresses common scenarios Kane, our principal Power BI expert, have encountered where clients require data to be masked in certain ways in reporting. Most often this is to […]

Today, we have some exciting news to share with you – the introduction of a new Power BI admin API that allows you to conveniently access all tenant settings in a single call.

RANK is a new DAX function to rank items based on multiple columns. This article introduces the RANK function and its differences with RANKX. DAX already of

In the June 23 release of Power BI desktop we has been blessed with a new card visual that not only will give a better performance compared to adding multiple cards in the past but it also gives us…

The enterprise Business Intelligence and IT community have been anxiously awaiting this capability for many years and it has finally arrived – at least in Preview form for testing and prototy…

We are excited to announce that Forrester has recognized Microsoft as a Leader in The Forrester Wave™: Augmented BI Platforms, Q2 2023. Microsoft received the highest score of any vendor in the strategy category.

We brought Marco in to help explain the TIMELINE update within DAX Studio. This can help you understand performance a bit deeper when optimizing your DAX and models. This is one to watch! DAX Studio https://daxstudio.org Marco Russo Tweets by marcorus https://www.linkedin.com/in/sqlbi/ https://sqlbi.com Optimizing DAX Video Course https://www.sqlbi.com/p/optimizing-dax-video-course/

An introduction to the Logical Thinking Process

Muti-tasking with the Power BI app in Teams is getting even better. Read the blog to learn how caching and take you back improve the experiences and keep you productive.

Lots of Vega Lite goodness to be enjoyed in Deneb. Contribute to Power-BI-guy/Deneb development by creating an account on GitHub.

Contribute to PBIQueryous/Deneb development by creating an account on GitHub.

Optimize Parquet files using V-Order in Microsoft Fabric for quicker reads, cost-effectiveness, and better performance on sorted Spark dataframes

This blogpost explains the revolutionary Microsoft Fabric, a SaaS analytics platform that seamlessly integrates various data and analytics services into a unified solution. With its foundation on the powerful Power BI platform, Microsoft Fabric empowers users with data-driven analytics and exceptional visualisation capabilities. From data integration to storage, processing, and collaboration, this comprehensive platform covers every aspect of the analytics lifecycle. By adopting a SaaS model, Microsoft Fabric offers accessibility, convenience, and scalability, enabling businesses of all sizes to harness the power of AI in their analytics endeavors.

In the data engineering field, we must ensure that large datasets are compressed efficiently to save storage space and reduce costs, but we also need to maintain strong query performance. This can be balanced by utilising the VertiParq engine and Delta in Microsoft Fabric.

We are pleased to announce the public preview of a Power BI Desktop Developer Mode, which offers a new save option to your Power BI developers that unblock source control and CI/CD best practices

Bring sexy back to your career by ditching your GUI-based comfort.

For many people, data storytelling is just an extension of data visualization. Most of the focus is spent on the explanatory data visualization techniques that are employed in data stories. By focusing primarily on the visuals, the two other key elements of data stories--data and narrative--are often misunderstood and overlooked. It's time for organizations to embrace a more balanced approach to data storytelling that is centered around the effective communication of insights, not just the data visualization aspects.

Welcome to the June 2023 update! This month, we are please to announce updatest to On-Object interaction, a new demo experience to the Power BI embedded playground which simplifies the process of exploring embedding Power BI in your application, creating Power BI reports instantly with Jupyter Notebooks, and Power BI Desktop Developer mode. Read on for all of these updates and more in Reporting, Data connectivity and preparation, Service, Embedded, Developers, and Visualizations.

With the February and March 2023 Desktop releases comes more features enabling us to enhance our KPI visualisations out of the box. This article talks specifically to the DAX function LINEST() and the new Subtitle and Dividers formatting options. For a simple enhancement, we can add the divider to KPI Cards, without title and subtitle,… Continue reading KPI trend indicators on Core Visuals

In my last article I introduced the three different connectivity modes that are available for Power BI to fetch data from a source, with a specific focus on when and where to use DirectQuery connections.  In this article I am going to go deeper and introduce the modelling aspects of a DirectQuery [...]Read More »

The New Card Visual is out an in preview – and it’s absolutely fantastic. With this first drop of the Card Visual we can see flexible formatting options such as accent bars, images, backgrounds, padding, spacing and alignment. For a more comprehensive look check out this post. There are a lot more features on the… Continue reading Adding sparklines to New Card Visual

New! Users can now generate a link to chart from organizational app and use it in PowerPoint. This newly added feature allows users to infuse data and insights from org app charts into their presentations and work with smart insights, filters, and live data.