In this blog, we’ll focus on the different ways of querying data in Synapse Real-Time Analytics. But before we begin, make sure to follow the steps in the Synapse Real-Time Analytics: Discovering the best ways to get data into a KQL database to ingest data into your KQL database.

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.

We are excited to announce direct access to Dataverse actions in Power Fx formulas as Preview feature (default on.) As a part of the Power Fx language, authors can now directly invoke a Dataverse action within a formula. A new Power Fx ‘Environment’ language object that authors can add to their app enables access to…

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.

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.

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.

If you have had a play around with Microsoft Fabric you will have seen that there are lots of different ways to get to your end goal. One of the most important decisions to make is whether to use a Lakehouse or Warehouse?

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…

TL;DR : using Fabric Python Notebook to Sort and Save  Parquet files  up to 100 GB shows that DuckDB is very competitive compared to Spark even when using Only half the resources available in a com…

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 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

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.

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.

Power BI Desktop has a new card visual that allows users to display multiple cards in a single container with full control over each card’s components. It supports multiple fields and offers refined formatting settings.

TL;DR ; Although the optimal file size and the row group size spec  is not published by Microsoft, PowerBI Direct Lake mode works just fine with Delta table generated by non-Microsoft tools an…

Export and import Power Query template files in Excel and Fabric

In this blog post I show how you can use the Power BI Field parameters to create a hierarchy for your field values