Power BI

This post is an overview of the improvements made to Datamart’s Visual and SQL Query editor, which is currently in Public Preview.

Metrics visual is now available.

In a previous article about Field parameters, I spoke about using them in cooperation with Calculation groups (LINK). I used them to get specific measures for selected dimensions from the dimensions field.

There is a hidden gem in the August 2022 release of Power BI Desktop: a secret new DAX function EvaluateAndLog that is not listed in the feature summary of the official blogpost. Yet this function …

My opinion on hiding the filter pane, what my personal preference is as well as the reasons why.

Describes enhanced refresh by using the Power BI REST API

Declutter and focus are two guidelines for creating clear and efficient visualizations.

One of the main challenges I see #powerbi admins of large enterprises is monitoring & troubleshoot all their on-prem Gateway Clusters. Each cluster has multiple gateway servers that are responsible to connect the Power BI service in the cloud to customer data sources, sometimes there are errors in t

This article introduces the Power BI workspace strategic planning decisions you should make at the tenant level.

Learn how to change properties without touching your mouse

Doing anything with Canvas Apps and SharePoint document libraries? Awesome! This is a pretty good way to restrict what your users can do in terms of manipulation of files and data. SharePoint would tend to give users too much control and access to change in comparison to how restricted we can make t

Learn how to leverage VertiPaq Analyzer tool to get a quick and convenient insight into your Power BI data model structure!

Azure Synapse Analytics July Update 2022  Welcome to the July 2022 update for Azure Synapse Analytics! This month, you will find information about Apache Spark 3.2 general availability, a new Cast transformation added to Synapse data flows, performance/cost improvements to Synapse Link for SQL, and ...

SP Editor is SharePoint Development Power Tool browser extension - pnp/sp-editor: SP Editor is SharePoint Development Power Tool browser extension

Phew! This one is going to be fun as the title should be "How to create a pipeline to incrementally copy over all datasets and subsequent tables from Google BigQuery to Azure Data Lake by using nested ForEach, If Condition activities and watermarks in Azure Data Factory" - but that title seemed a we

Last week I introduced mini-projects as one pillar of my graduate visualization course. A interesting outgrow of that activity is a set if data visualization clarity and aesthetics guidelines we developed over time while reviewing the solutions our students submitted for these exercises.

Three concepts from visual perception that can help you think better about clarity and aesthetics

Reflections on my frustration teaching data visualization without focusing on effective data-driven thinking

A few months ago, I was asked to build a line chart with target areas, something like the chart below (which by the way will be our final solution!): At the time I could not really find an easy way to achieve this... Until error bars came out! Don't be fooled though, it's still a bit tricky to build a line chart like this, however I found it way easier now than before. So, you must be thinking now "how did you do that?". Well, let's find out! 1) I started out with my base chart, which is just sh

Our Ideas site has been the main place for you to leave suggestions. the past year we have made improvements to the ideas site to keep the site secure, spam free and allow users to submit ideas through the Ideas portal. Many of you have since shared feedback and suggestions on how we can further improve the ideas site. Today we would like to share the upcoming roadmap and improvements we have planned for the Ideas site to address the feedback that has been raised.

Another reason why using a measure table in a Power BI model is a good idea

Why are some visualizations so easy to understand at first sight while others seem to be some sort of graphical puzzle? Why do some visualizations need to be relearned every time you see them again, whereas others need only one simple initial exposure?

Dataflows are an important component in the Power BI architecture. Using them can enhance the development and maintenance of your Power BI solution significantly. However, there are many Power BI …

Training users is important in every Power BI project. It’s particularly important when implementing Power BI, or if users are not familiar with Power BI reports. However, creating good training material is time-consuming, and difficult. In this article, I introduce reporTee, a licensed, out-of-the

Introduction to datamarts5 minutes to read3 contributorsBusiness users rely heavily on centrally governed data sources built by information technology teams (IT), but it can take months for an IT …

This blog post explains how to call an API that uses cookie authentication from a Logic App. Hint; there's a little secret to it!

By Norm Nicholl, Cloud Solution Architect and Ryan Coffman, Cloud Solution Architect As Microsoft Azure matures and grows, its data capabilities become....