Power BI

DataOps Principle #10: Orchestration

If you are a Power BI report developer, you might have experienced the case I’m describing in this post. You did your utmost best to setup a decent DT(A)P process, where you clearly separate …

One approach to optimise DAX queries is to focus on the number of Storage Engine (SE) calls generated by a query and look for ways to provide the same result using fewer SE calls. If a query takes 30 seconds to run and makes hundreds of SE calls, reducing the number of SE calls almost … Continue reading DAX 1-Column Fusion

What if I tell there is a way to show only the desired data labels in PowerBI and that is without any extra visuals? It can be applied to almost all the visuals I tried, just need to write DAX. There are two tricks I have used here the first trick I came across was by luck, and I am not sure if anyo

The Ultimate EPL Fantasy Football Report!

Connecting Power BI to Microsoft GraphYou are almost near to achieve your goal of becoming Microsoft Power Platform expert. Till now we expect that you have read all the previous blogs and this is our fifth blog. Let have a top-level view of previous blogs.Revision:In first blog we have learned the b

Microsoft Power BI is a business analytics tool which allows users to gain insight from their data. You can easily create an interactive dashboard by just dragging and dropping data columns into the visualization plane. In this article, I'll show you how to use Python to help you leverage

There has been confusion for a while when it comes to Microsoft Docs and the two distinct sets of documentation for dedicated SQL pools. When you do an internet search for a Synapse related doc and land on Microsoft Docs site, the left-hand navigation has a toggle switch between two sets of docume...

We have added a new template in the ADF and Azure Synapse Pipelines template gallery that allows you to copy data from ADLS (Azure Data Lake Storage) Gen2 account to an Azure SQL Database. This template is a code sample, to be used as guidance for customers that are using the preview feature of incr...

This blog sets the scene for good power platform governance, demonstrates what patterns need to be identified for good implementation, and what should be considered technically

Recently when I was adding the new column in Microsoft Dataverse from the PREVIEW maker portal (https://make.preview.powerapps.com/) I was amazed by looking at the new option in the Datatype available named “Formula”. In this blog, we will focus on the introduction and related use cases where thi

Generate row numbers for a Power Apps collection with this formula. Copy and paste this code into your own app.

part 1 of building Power Apps based on Google's Material Design

StrataScratch is a data science interview platform that has over 1000+ real interview questions from top tech companies like Facebook, Amazon, Google, and more.

Today, we are excited to announce the public preview of Multiple Audiences in the Power BI Apps, one of the highly requested features from the community. With multiple audiences for an App, now Power BI App author can create multiple audience groups within the same App and assign different permissions to each group.

DAX Studio 3 has been released today. This new major version has a new user interface and user experience, providing a modern look and feel without losing a

The problem: how to make SQL dynamic?

In recent years, mental health of professionals has become an increasing concern. Here, I share a 5-step approach to use mindfulness to combat disruptive thoughts & feelings and improve mental wellbeing.

Vertipaq is the actual database engine used in Power BI. It is also the engine used in Analysis Services Tabular and Excel Power Pivot.One of the reasons behind Vertipaq’s great performance is due to the different compression techniques that it applies to the data. The overall purpose of the different compression techniques used is to […]

This was my longtime aim to create this post, and finally, I will write about it here on how to call Azure ML Rest API inside Powe Query even if you don’t have Power BI Premium.Of course, some limitations on the number of API calls need to consider while using your Rest API.Thanks to Chris Read more about Azure Machine Learning Call API from Power Query[…]

Learn how to read and write data to Google BigQuery using Databricks.

In this tutorial I will show you - step by step - how to flatten the Google Analytics 4 export schema with the purpose of using the data in a relational database outside of BigQuery.

A few data traps that data consumers and data storytellers alike should beware of to avoid getting the wrong idea

Contribute to samaguire/TabularEditor3Scripts development by creating an account on GitHub.

Learn how Microsoft successfully drives a data culture for business decision making. It describes their strategy and vision for BI.

This is a repository for Microsoft Power Automate, Power Apps, and Azure Logic Apps connectors - PowerPlatformConnectors/independent-publisher-connectors/Sessionize at dev · microsoft/PowerPlatform...

Being able to do a data driven report subscription with Power BI and Paginated reports is a common request we hear from many customers. Let’s say you want to send a PDF version of a report to…

We are excited to share that Gartner has positioned Microsoft as a Leader once again in the 2022 Gartner Magic Quadrant for Data Integration Tools. We believe this recognition shows our continued growth and ongoing commitment to delivering comprehensive and cost-effective data integration solu...

This is the second article in a series on the introduction to the EvaluateAndLog function. As I explained last time, EvaluateAndLog can be used to print to the debug output the intermediate result …