Power BI

Refer to this list for deciding which sessions to attend while you are at the Microsoft Business Applications Summit 2019 in Atlanta

In this post, we will import data from an Excel spreadsheet into a model-driven PowerApp, creating a Data Integration Project that uses Power Query. First, let’s look at a spreadsheet we have. It contains 2 accounts, with the account name and revenue: This spreadsheet is sitting in a SharePoint library. Let’s go to PowerApps.com and pull up our model-driven app. Select Entities: Clicking on Accounts, we can see the data … Continue reading Import Excel Data into a Model Driven PowerApp using Data Integration Project

Today, most businesses rely on Salesforce to track their employee activity, pipelines, and revenue. While they’re able to monitor their progress and growth, one area they are unaware of is employee engagement. A major segment of the sales team is found to be disengaged and lacks the motivation to ac...

We have added AI metrics to complete the suite of workload metrics available in the Power BI Premium capacity metrics app (version 1.10.1.7), making it a one stop shop for admins.

The default configuration for Power BI dataset is to wipe out the entire data and re-load it again. This can be a long process if you have a big dataset. In this article, I explain how you can set up an incremental refresh in Power BI, and what are the requirements for it. Incremental Refresh…

When using Power BI it is interesting to see how much memory the PBIX uses. Not only that but if you are looking to move to Power BI Premium you need to understand the requirements

It is very common to need to transform data from one “shape” to another “shape” before it can be used inside Power BI for analysis (although many beginners don’t reali…

Clicking on the Embed option from the Send Survey tab, there are three options.Let's look at how to embed a survey in to a page on your website.

In this article, I will describe how to automate the creation of complex PDF documents from a template. Let us say we have a sales department. They are tired of filling the same documents with brief changes again and again. We could provide them some form for filling data and generate documents automatically.

Creating Two-Tiered, Multi-Frequency Period Cycles Using List.Generate, Column References, and Internal/External Context in Power Query

I post about Power BI dataflows a lot, but that’s mainly because I love them. My background in data preparation and ETL, combined with dataflows’ general awesomeness makes them a natura…

The Paginated Reports team closes out May with another “New Feature Friday” blog post announcing one of the biggest enhancements to e-mail subscriptions in Power BI to date. With today’s update, Paginated Reports users can set up an e-mail subscription for themselves and their colleagues and choose the parameter values they wish to use for …

Reading Time: 4 minutes The Navigation Builder is a solid new feature for Power BI Service that enables a customized app experience for viewers. Read about this feature and the entire app navigation r…

This blog post covers the latest updates for Power BI embedded analytics and Custom Visuals.

Power BI is an excellent tool for departments or small organisations getting started with their BI solution. Unless some time is spent organising the solution, however, it can become cluttered. In this article, Gogula Aryalingam explains how to streamline the solution to keep it organized and efficient.

On May 17th Friday afternoon, Visual BI’s ValQ for modern digital planning was introduced to the world through Microsoft’s May 2019 Power BI Desktop summary blog. This made the week a blockbuster for ValQ (With 1,000+ product downloads and 100K+ views) and the Power BI user community (as per their s...

Explore Power BI videos to see how innovative Power BI features work together to provide business intelligence insights at a massive scale.

When we start using Power BI in a smaller scale, things tend to work quite smoothly even if we have built not-so-good models with not-so-great calculations. But when we start loading more and more …

We are excited to announce that we have added a new experience rolling out this week for selecting data sources in canvas apps and to allow using the Common Data Services views as a filter on entities. Configuring a gallery or data table control is much easier with a prompt guiding the data source or connector to use. With this new experience is an improved data access to Common Data Service and will soon include all of the recent connection improvements. To streamline use of Common Data Service, the data source selection includes a list of suggested entities. The ability ...

Metadata customization for Common Data Service entities is now faster and more seamless than ever.

Nobody wants to lose unsaved changed. And yet there are many ways to exit a canvas app while still in a dirty state, from closing the browser tab to swiping back to the list of apps on the phone. Now there is a way to prevent losing unsaved changes. The App object has two new … Continue reading “ConfirmExit for canvas apps”

I use a lot of variables to detect the date ranges. If a visual is filtered to one day, like 6/10/2019, the measure will show "20190610". If a full month, like June of 2019, it shows "201906". If one year, it would be "2019". It can also do multiple years 2019-2025, or multiple months: 202011-202103.

One of the things you should know when working with PowerQuery is that you can get a list of all functions in M by adding a blank query and use the #shared expression to get all the functions. This…

This article describes how to import into DAX Studio the performance metrics that can be exported by the Power BI Performance Analyzer, simplifying the anal

Most of the time, you would like to know how the data quality looks like in your tables. Although, this is a process that you mainly check at the time of data preparation, having such report for end u…

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup140 Tech Video: https://guyinacu.be/appnav Sources Power BI Governance – Approve/Reject all datase…

The weekly Power BI Roundup, where in this weeks roundup I go through the updates to Paginated reports which shows different attachment types

Get ready for the imminent release of Shared and Certified datasets in Power BI! In the coming days we will start rolling out the public preview of a set of capabilities across the Power BI service…

A new update to DAX Studio is now available at https://daxstudio.org which includes the following: New Features Import Power BI Performance Data Support for Display Folders in the Metadata pane #127 A…