Getting Data Into Shape for Reporting with Power BI
Even for small, informal BI projects, shaping the data into a dimensional model alleviates complexity, speeds up slow calculations and reduces the data model storage size. I conclude this post by r…
The first iteration of such an effort is usually a valuable discovery method and learning experience. Great… treat it as such; take notes, make note of the good parts and then throw it away and start over! In Fredrick Brooks’ “The Mythical Man Month“, he cites that for most engineering projects, the first six attempts should be abandoned before the team will be prepared to start over and complete the work successfully. Brooks was a chemical engineer before working for IBM; and hopefully, our methods in the data engineering business are more effective then his 6-to-1 rule. But, this makes the case the prototypes and proof-of-concept projects are a critical part of the learning path.
How to create a dynamic legend with dynamic measure
Field parameters are great for dynamic legends, but the creation of a dyanmic measure + time intel chart can be time consuming. Most of it can be automated.
Snowflake Data Sharing OR Power BI Dataset Sharing
When it comes to Snowflake, data sharing is one of the important features that stands out from other competitors. This feature is so catchy as data sharing is something most organizations are strug…
How to use Actionable Messages in Outlook with Power Automate
Power Automate makes it easy to send actionable messages to Microsoft Teams, but did you know it is possible to send an actionable message from a Power Automate flow in an email from a user account?
Power Automate and the Power Apps trigger - part 3 - Impersonation - About365
This blog series will cover the Power Apps trigger in Power Automate. I will describe how you can trigger a flow from your Power App, how you can provide parameters from your Power App to your flow and how to impersonate actions. This is part 3 of this blog series, which will cover impersonation of […]
This is the fourth and the last article on the EvaluateAndLog function. While DAX developers were excited about the prospect of printing the values of a portion of a DAX expression, many of the ear…
In this blog post, I'm going to share with you a recent success story from one of my customers. For privacy reasons I can't mention the customer itself, but I will give you a little overview of the company and the kind of industry they are in. With this success story, I hope I can inspire readers and customers to think more carefully about their design choices when building reports in Power BI. COMPANY OVERVIEW Customer: Recruiting Analytics (for privacy reasons, I can't reveal the real name of
Calculate Nth Business Day From Date in Power Query - BI Gorilla
You want to return the nth business day from a date in Power Query. And this offset should take into account holidays and weekends. It's a common requirement
Learn how to use Timeline Visual in Power BI to show data per date in a timeline format | Horizontal Timeline in Power BI | Virtical Power BI Timeline visual
Announcing public preview of Content Security Policy for Power Apps
We’re excited to announce the public preview of Content Security Policy (CSP) configuration for Power Apps. CSP can be configured using the settings under the Privacy + Security settings section of an environment in Power Platform Admin Center.
How to generate an HTML table with the output of a SQL Server query and send it from Outlook by using Power Platform
How to generate an HTML table with a SQL Server query and send it from Outlook using Power Platform We will make use of the Premium SQL Server connector and the standard Outlook connector.
Using the ParseJSON function and a generic flow to call any SharePoint Rest API endpoint and manipulate the results from Power Apps - michelcarlo
How to use the new ParseJSON option in combination with Power Automate to send requests to the SharePoint Rest API and parse them back, in a generic way.
Introducing the Creator Kit – Efficiently create performant Fluent UI based Power Apps
Today, we are proud to formally introduce the first stable release of the Power Platform Creator Kit – a free toolkit that optimizes development in Power Apps.
Welcome to the Power Apps monthly feature update! We will use this blog to share a summary of product, community, and learning updates from throughout the month so you can access it in one easy place. A variety of new and highly anticipated features are now available which we are very excited to share: Trust &hellip; <p class="link-more"><a href="https://powerapps.microsoft.com/en-us/blog/whats-new-power-apps-august-2022-feature-update/" class="more-link">Continue reading<span class="screen-reader-text"> &#8220;What’s new: Power Apps August 2022 Feature Update&#8221;</span></a></p>
Announcing Public Preview for Power Platform App Install API &#038; Tools Support
We are pleased to announce the Public Preview of Power Platform Application Install API! This capability enables automation of install and update experiences that are offered only through the Power Platform Admin Center experience today. Installs can also be automated for applications available from AppSource provided at least one such install of the said application &hellip; <p class="link-more"><a href="https://powerapps.microsoft.com/en-us/blog/announcing-public-preview-for-power-platform-app-install-api-tools-support/" class="more-link">Continue reading<span class="screen-reader-text"> &#8220;Announcing Public Preview for Power Platform App Install API &#038; Tools Support&#8221;</span></a></p>
Behind the scenes, your IT and Center of Excellence team spends time configuring, managing and nurturing the adoption of the Power Platform. In this post, learn about a new tool to help you plan who you need on your team and find the highest-impact opportunities to streamline your administrative effort.
Defining different formats for values and totals in Power BI can be achieved with the use of a calculation group which will reuse the original format string.