Power BI

With data lakes becoming popular, and Azure Data Lake Store (ADLS) Gen2 being used for many of them, a common question I am asked about is “How can I access data in ADLS Gen2 instead of a cop…

Power BI reports can get slow if you have huge amount of data. One of the ways to speed up the performance is to get the smaller part of the data, only the part that is needed for analysis. Most of the times, a date condition is a good filter for that. You might only…

Welcome back to another “New Feature Friday” for Paginated Reports in the Power BI service.  We’re pleased to announce three new features rolling out around paginated reports.

Learn how to work with Power BI files (PBIX) inside SharePoint. There are a number of suggesstions to make your experince a pleasant one. Read Here.

This blog post details how to use Power Query with Power BI to repeat a value across all the rows in a table. This is usefull in certain scenarios

This is Part 3 in my series of blogs posts (fairly infrequent), about report design options, based around the cognitive process. This post I’ll be looking at framing the answer. What is frami…

Patrick looks at other tools you can use against the Power BI Desktop diagnostic port besides DAX Studio. From clearing the model cache, to getting other information, this is a handy way to look at your Power BI Desktop file. PowerShell – Get Diagnostic Port Clear Model Cache XMLA Download SQL Server Managment Studio

4 turn key Solutions for Event management (Thrive Conference), Company News & Actionable Cards (Thrive Home), Employee Praise (Kudos) and Organizational Information Solution (People)

In this article I will highlight 10 interesting flow hacks/ workarounds that might help you in building your flows. This article is inspired by a

In this post, we will discuss another approach for merging multiple documents into a single PDF using Microsoft Flow. In previous blog posts, we had a look at the Iterative approach and REST API approach to merge documents to PDF. Both approaches have their own advantages and disadvantages: For the...

There are many things you do so often that you don’t think how they work. They just work and that is enough. Not today. I would like to discuss a Power Query query which is automatically generated whe…

<p>We’ve released lots of new features and enhancements to our Data Integration capabilities in PowerApps recently, enabling users to seamlessly connect to, transform and combine data from a wid…

<p>Throughout the month of October, we’ll start rolling out an improved header to the various areas within PowerApps: the maker portal, canvas apps, and model-driven apps.</p>

September release of Gateway

In 2015 I released the first version of VertiPaq Analyzer, a tool to quickly analyze the structure and data distribution of a Tabular model that can be used

App checker now includes optimization tips to help you improve the run-time performance of your apps.

PowerApps component framework for canvas applications.

Here’s a quick recap of all the features and announcements in the monthly of August.

I was exploring MS Flow and working on a article series for SharePoint based action in flow and I accidentally found something interesting. On below

Under time pressure today… So I’ll just leave these here. Yes, these images are all Power BI. They are all clickable links to interactive pages. Rather than my usual wall of text… How about we just open this up to Q&A today? Leave questions as comments and I will do my best to answer them all in

Adam breaks down v-core pooling with Power BI Premium. Explaining where the v-cores come from and how creating a Power BI Premium node affects the v-core pool.

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

We are excited to announce new improvements to Power BI dataflows releasing this month including non-admin gateway support and further improvements to the enhanced compute engine. We also have released a new best practices guide for dataflows to help you make the best use of the new enhanced compute engine.

We have plenty of resources to get ready for the upcoming release wave with confidence. Learn more about the upcoming Power BI features included in 2019 release wave 2 with our new overview video and guide, and understand key milestones in this process.

In part 2 of this mini series about organising your flows into functions I will look at calling multiple functions. If you missed part 1 then please have a look at Function Libraries in Microsoft F…

The Microsoft Flow Conference 2019 Content is Available on-demand! Check it out and connect with all of the presenters!

This article describes how to compute previous year values up to a certain date. This is useful in case the data is presenting incomplete months or years. I