Power BI

In our previous Power BI automation blog, we utilized the Power Platform in combination with Azure SQL to store refresh history of our datasets leveraging the Power BI REST API when on a Power BI shared capacity. A solution to manage Power BI dataset refreshes is particularly useful when data source refresh times are variable and end users need to know when dataset refreshes are successful. However, Power Automate and Azure SQL create two failure points. This solution also requires additional licensing cost in Power Automate to leverage premium data connectors to Azure SQL. So, how can we consolidate the number of tools we use and at the same time leverage the security features and access controls that Azure provides?

An new diagram of Power BI Datamarts is now available. It includes the technical components of a Power BI datamart. This blog post includes a brief summary of each technical component.

We are committed to helping our Azure Analysis Services customers unlock the enormous capabilities of Power BI as a superset of Azure Analysis Services through a smooth migration path to Power BI. As part of this effort, we are happy to announce today that Power BI has reached yet another compatibility milestone with the introduction of explicit Dataset Write permissions.

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 …