Author: @SuryaJ  is a Program Manager in the Azure Synapse Customer Success Engineering (CSE) team.   Introduction Kusto Query Language (KQL) is a powerful query language to analyse large volumes of structured, semi structured and unstructured (Free Text) data. It has inbuilt operators and functions...

Microsoft announces the launch of Data Wrangler, a data-centric user interface that generates Python code to help data scientists complete their data preparation tasks faster and with fewer errors.

If, like me (and Ruth), you spend your life in Power BI but have a lingering feeling that you should get round to learning Python for data analysis sometime then here’s something you should c…

Let’s imagine you’re running a (fictive) company, and you’re short on data & analytics experts. Therefore, you decide to in hire expertise, and they will help you build your P…

I believe that — as for any other technologies — algorithms and artificial intelligence will amplify human abilities more than they will…

ApproximateDistinctCount now works for BigQuery, Databricks and Snowflake sources in Power BI

Businesses today are constantly facing new and bigger challenges. Technology is diversifying and evolving faster than ever to address these issues, giving industries across the board a growing number of solutions to sift through.

In this blog post I explain how to use Power Automate and using an HTTPS URL to refresh a Power BI Dataset with email notification.

Microsoft Loop is the latest app from Microsoft to help teams think, plan, and create together like never before. We have been listening to many customers in our early feedback sessions, and in these sessions a pattern emerged. Every person we spoke to valued collaboration. And they continued to str...

As organizations continue to evolve in these dynamic times, they need modern tools that can embrace ambiguity and enable people to work where and how they want to in order to be effective. Microsoft Loop is the perfect solution for your teams to think, plan, and create together, like never before, e...

Inspired by Darrens Gosbell’s excellent blog post – Automatically generating measure descriptions for Power BI and Analysis Services with ChatGPT and Tabular Editor – Random Procrastina…

When trying to get your DAX measures to work correctly, there are a number of tools you can use to debug, which I will briefly mention, but not go into depth on. Instead, this post is about how to think about debugging your code. I am focusing on DAX here, but many of the methods would apply to an

This article describes how Power BI uses the Group By Columns attribute of a column and how you can leverage it in specific scenarios. In Power BI you can s

Want to make multiple selections across all the slicers on your report page then apply them at once? Need a quick way to clear all the slicer’s selections at once, without a bookmark? Now you can!

General availability for the additional Analysis Services settings for workspaces in Power BI.

Data development projects, especially those involving multiple developers, languages, and platforms, can quickly become overwhelming without proper organization and consistency. One solution to this challenge is to implement a style guide.

In this post, I will describe how to implement Multiple Linear Regression in Power BI using DAX only.

In a recent post where I described how to implement multiple linear regression in Power BI, I had to perform one hot encoding to make my categorical variable usable by the model. So I decided to make another short post to explain what is hot encoding and how to implement it in Power BI using Power Query. Why do need to perform Hot Encoding? In machine learning or statistical algorithms, many models require to have only numerical input variables. So...p class="read-more"a class="btn btn-default" href="https://datakuity.com/2023/03/15/one-hot-encoding-in-power-bi/" Read Morespan class="screen-reader-text" Read More/span/a/p

Top 5 tips for improving performance of hierarchies in Power BI Metrics

In 2019, we launched the Center of Excellence (CoE) Starter Kit – a set of templates that are designed to help you get started with developing a strategy for adopting, maintaining and supporting Microsoft Power Platform, with a focus on Power Apps and Power Automate. In the past three years we’ve continued to evolve and innovate as we learn from our customers. Today we’re excited to announce that the CoE Starter Kit can now use data provided by self-serve analytics as a foundation for inventory and telemetry, enabling rich insights built for scale.

Today, we’re announcing a next-generation AI Copilot in Microsoft Power Apps that will transform how we build and interact with software applications. With the power of large language models, we are advancing to the next step in the evolution of code abstraction—moving from custom code, to low-code, to natural language authoring where human and machine work side by side to build applications together.

Use Microsoft Power Platform and next-generation AI to solve business problems and enhance productivity in the flow of work. Learn more.

The union of AI and low-code revolutionizes the way solutions are built and fundamentally transforms the way people work, collaborate, and create. Learn more.

How to make Dynamic Icons in Power BI...

I will discuss one of my favorite techniques around Power BI custom icons, which uses custom icons in a dynamic way in Power BI visuals.

In this post we will talk through a step-by-step guide for how to design and build custom buttons in Power BI. We'll start with the basic foundations of shape and form, to applying icons, states, and actions with the view to extending your brand collateral across your report design and UI.

We are happy to finally release our February update for the Power Platform CLI. For those of you who are new, our pattern has been that we release an update for the work done in the last month, in the current month. Usually, we each include some new capabilities, along with the usual fixes that…

A new Power Fx editing experience Today we are announcing a new Power Fx formula editing experience in Power Apps Studio.  The new formula editor is available an experimental feature that we encourage you to turn on in your apps and try out!  The new editor is based on the powerful Monaco shared code editor…

In this article, I clearly layout the differences when using FILTER or CALCULATE TABLE.