Power BI

The history of reporting tools in the Microsoft reporting universe is a long story and many tools have taken part in that journey (SQL Server Reporting Services, Performance Point Services, Excel,…). …

This knowledgebase article provides step by step instructions on how to create custom reusable controls in PowerApps. Find out how...

I recently had a look at my last version of my Infographic and I realized that I had not updated it for a few months and there has been a lot of incredible additions to the Power BI ecosystem. My i…

This has been a great year for Power BI service admins. In July, we shipped APIs and PowerShell cmdlets for Power BI management, and recently we also released a preview version of a Workspaces page in the Power BI Admin Portal (see the screenshot below). This page lists all the workspaces in a tenant and … Continue reading “Workspace Management in the Admin Portal”

<p>Take your model-driven form authoring experience to the next level with the new model-driven form designer. It provides a modern, clean and productive interface for makers when authoring mode…

In the June Power BI update, they announced the addition of Row Level Security (RLS) for Power BI.

In this article, we will learn Key Performance Indicators usage in Power BI and solve a business case problem through Power BI.

I see a lot of Power BI users asking for the ability to set a default slicer selection in their reports. Although this isn’t natively supported as of yet, we can imitate this functionality with a little bit of DAX! A general overview of the process to accomplish this task is as follows: Create a slicer. Create a

There are two types of PowerApps canvas apps, and it may not be obvious that these are two different things, but it is IMPORTANT that you understand this BEFORE creating a PowerApp.

A review of PowerApps, PowerApps Web Studio, and the correlated role of the power user.

In my current project, one of the user requirement was to have a filter on the Year Slicer. To explain in detail, we have various measures to show metrics for…

Have you heard about Yammer? It is a social network for organizations, kind of a “private Facebook”. Let’s imagine your organization is using Yammer as an internal platform for di…

The Power BI Premium Capacity Metrics (version 1.10) app makes navigating and viewing metrics at workspace level easier.

The order of the columns in a table in a Power BI dataset doesn’t matter all that much, especially because the Fields pane in Power BI Desktop ignores the original column order and lists the column…

Activating bidirectional cross-filter in a Tabular data model might create ambiguous paths in the chain of relationships, resulting in very dangerous models

<p>We continue to expand our Canvas support for the Common Data Service for Apps, on the road to CDS + Canvas = Awesome. With this installment we have refined how Option Sets and Two…

This month we have a number of great updates for Microsoft Flow. First, we now clear notifications in the notification center once you have viewed any failures. Flow has documented its Web APIs; for example, you can now programmatically create, share, or delete flows. Flow makers now have more control over the inputs that buttons take, and a new support experience will make it easy to find solutions to issues in the Microsoft Flow portal, without having to open a support ticket. Finally, there are eight new connectors this month including <a href="https://flow.microsoft.com/connectors/sh...

Catch the last Power BI roundup for 2018! Merry Christmas, happy holidays and have a great New Year! 🎄❄🎅 Financial Times Visual Vocabulary: Power BI Edition (@SQLJason) Power Query Advanced Editor k…

In our ongoing efforts for modernizing the way we update Dynamics 365 for Customer Engagement, we are changing the way you have access to new features and functionality. Some of the changes require ex…

Overview of creating a model-driven business app using PowerApps with Dynamics 365 and building up your business data and processes in the Common Data Service to model forms, views, and other componen…

Azure Data Factory v2 (ADF) has a new feature in public preview called Data Flow. I have usually described ADF as an orchestration tool instead of an Extract-Transform-Load (ETL) tool since it has…

Today, we’re excited to announce our next big step forward: we’re bringing PowerApps together with the platform that powers Dynamics 365.

In Part 1 of this series of posts I have looked at creating a new custom connector. If after reading part 1 you are still happy to do all the DIY, then here is the next part of my series about cust…

Microsoft Flow has currently 211 connectors available. Sometimes however you might find that you need to create custom connectors into applications that aren’t available in the list of connec…

We've been on a journey to modernize user experiences throughout SharePoint. Lists and libraries are the primary containers for data and content, enriched with custom metadata. Previously, we introduced column formatting, which lets you cut and paste JSON scripts into a formatting window to add...

Welcome to post number 6 in my series concerning Microsoft Exam 70-778. The series aims to provide a revision tool for those who are looking at taking the exam and to also provide an introduction i…

I’m a heavy user and fan of Power BI. It’s a great tool for building reports from multiple data sources and easily sharing them with others. I use it for a variety of internal needs …

I recently did this webinar for Power BI in the studios in Redmond. The webinar goes into details on the data model with Power Query, importing data, relationships and DAX....

If you have used SSRS, you know that paginated reports are very customizable, and you can make almost any property expression-based. Power BI is yet to deliver expression-based properties to change se…