Power BI

Learn how to design groundbreaking data visualizations and data products that people can’t live without.

Over the last few weeks we have been working on a Dataflow extension for our Power BI templates. The idea is to extract the existing queries from the

Do you know this message? "This file can't be downloaded yet. You can't download this file right now because it's been modified using an XMLA endpoint."

Today, I’m excited to announce the general availability of database designer in Azure Synapse Analytics. The database designer allows users to visually create databases within Synapse Studio without writing a single line of code. The designer also enables users to explore database templates, customiz

This topic covers lockbox for Power Platform.

Learn how to export table data to an Azure Synapse Analytics and Azure Data Lake in Power Apps

Learn how to fix the "Error when trying to retrieve data from the network" in Power Apps using 3 different methods!

Do you work as part of a data science team that spends a lot of time re-creating features? A Feature store is a centralised repository that allows data scientists, machine learning engineers, and data engineers to collaborate, share and discover features. This article will walk you through the proce

Reference architectures are great but how do you secure your new Data Lakehouse platform enough to make InfoSec happy? Let’s dive into design patterns for securing Databricks

Building upon Azure Databricks, I'll move from the compute engine to data storage. Things are a little simpler to secure but the plethora of options available can have significant impacts on usability and cost

In this post, we will take a step by step approach to simplify a report with 6 pages + 12 measures into 1 page report + 1 measure. After optimising the report, we will explore a change that will …

Delegation is both a fundamentally important and tricky to master topic. Let’s take a moment to understand the impact of delegation on app building, complete with some practical examples and …

Ever since I started my new adventure around low-code I have been trying to optimize my workflow. One of the things I started doing right away was around implem

Microsoft releasing new functionality can be an interesting experience, to say the least. As a cloud platform (SAAS – Software As A Service), functionality is released the entire time. A user could log off on Friday for the weekend, and come back on Monday morning to find that something has changed slightly, or a new … Continue reading Staying up to date with release information →

Building a Dynamic KPI card with Calculation Groups allows to modify the base measure as well as the transformations to use for comparison.

Do you fancy a quick data visualization for your ad-hoc queries over SQL pools in Azure Synapse Analytics? Synapse Studio gets you covered!

Shared Datasets have been around for quite a while now. In June 2019, Microsoft announced a new feature called Shared and Certified Datasets with the mindset of supporting enterprise-grade BI within the Power BI ecosystem. In essence, the shared dataset feature allows organisations to have a single source of truth across the organisation serving many … Continue reading Thin Reports, What Are They, Why Should I Care and How Can I Create Them?

Struggling with using Row-Level Security (RLS) together with Object-Level Security (OLS) in Power BI? You think it can’t be done? Think again! Patrick shows you how to use both together. Announcement Blog: https://powerbi.microsoft.com/blog/object-level-security-ols-is-now-generally-available-in-power-bi-premium-and-pro/ Analysis Services Doc: https://docs.microsoft.com/analysis-services/tabular-models/object-level-security FourMoo: https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specific-users-in-power-bi/

This blog post shows the users all the Power BI reports they have got access to, and details the steps in Power BI Desktop.

Have you ever wanted to quickly visualize your data using built-in features in Synapse Analytics Spark pool? Check how simple and easy is to do that!

Learn the top five most common mistakes in Power BI development and how to avoid them to have a better Power BI solution.

I am happy to announce that we are adding Excel and SharePoint to the Virtual Connection Providers for Virtual Tables. You may have used the SQL virtual connection provider during its public preview and now we are happy to respond to you requests for more data sources by enabling this functionality for two of the largest external data sources for Power Apps.

This content applies to: Power Query Online Power BI datasets We are excited to announce three new features for the VNet data Gateway! New capability to create VNet data gateway clusters. You can use a cluster of virtual network data gateways to load balance the queries executing on the cluster and to avoid a single […]

I was intrigued why Tableau and PowerBI have a different behavior when operating in a Direct Query Mode ( Tableau call it Live Mode), I always assumed it is just a driver difference, but it seems i…

A few months ago one of my colleagues at Microsoft, David Browne, showed me an interesting Power Query problem with how the Xml.Tables and Xml.Document M functions handle null or missing values. I&…

Recently, I have had a challenge at a customer, where a central teams maintains many dataflows in Power BI, to store their only and single version of the truth. However, this central team maintaine…

Did you ever experience a long waiting time while opening a Power BI Desktop file? There could be many reasons for that, but if you have calculated columns