Power BI

Learn what is new in the Visual Studio Code March 2023 Release (1.77)

Enhance your coding with AI-powered suggestions from GitHub Copilot in Visual Studio Code.

Enhance your coding with AI-powered suggestions from GitHub Copilot in Visual Studio Code.

Learn about the Visual Studio Code team's experience and future with GitHub Copilot artificial intelligence

In this article, we tackle the growing issue of ‘report-specific objects’, dataset measures and tables created to fill specific report visual requirements, why they negatively impact self-service users, and best practices to mitigate this impact.

An introduction to M data structures and how understanding these structures helps to apply more complex transformations to your data.

An alternative way to import SharePoint list data into Power BI.

Learn more about delta lakes and how thwy work from Gerhard.

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

This page presents examples of Vega data visualizations created by Andrzej Leszkiewicz Vega is a declarative language for creating highly customizable interactive visualization designs. Vega … Read More

Power Query everything! Learn how to leverage List.Zip function to solve one of the most common data transformation challenges!

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