Your Brain & Report Design Part 3 – 10% or 1 in 10?
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 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…
What’s New in Dataflows and Data Integration – September 2019
<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…
The common Microsoft header is coming to PowerApps
<p>Throughout the month of October, we&#8217;ll start rolling out an improved header to the various areas within PowerApps: the maker portal, canvas apps, and model-driven apps.</p>
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
Yes, Power BI Can Do THIS: Free, Interactive NFL Stats
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.
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.
Learn more about the new innovations in Power BI starting October 2019
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…
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
Some Methods for Calculating Quarter in DAX for Power BI
You might have wondered that there is no DAX Quarter function in Power BI. Here in this short blog post, I explain some easy methods for calculating quarter. If you like to learn more about Power BI, read Power BI book from Rookie to Rock Star. Sample Data To start this example, you can open…
Modeling stock-type indicators: headcount, occupancy, and more!
Stock-type indicators are more complex to calculate than purely additive-type indicators. The most important point to consider is that each calculation has its pro and cons, and choosing the “best” approach will depend on these parameters.