Blog

How To

How To: Start Working with the PowerApps Component Framework

The PowerApps component framework (PCF) lets developers build re-usable code snippets called “Components” for model driven and canvas applications. The components can be used in multiple applications to enhance the user experience and drive a business use case. One of the examples I’ve run into is using the map functionality

How To

How To: Disable Quick Edit in Office 365 SharePoint Online

There are situations in SharePoint where it’s better to not allow users to “Quick Edit” a list. For example, a use case where lists get updated via Power Automate and some fields are hidden from the input form it would be problematic to let users Quick Edit an item. In

Power BI

External Tooling in Power BI

External tooling is incredibly useful for extending capabilities in Power BI that might not be native to the application. As an example, the DAX editor in Power BI itself can be really cumbersome to develop larger DAX statements. DAX Studio negates this issue by giving you a dedicated environment to

Power BI

Why I Don’t Like Measure Tables in Power BI

Using a measures table in Power BI is generally considered best practice, and there are certain advantages to using one. However, I’ve found in my experience that the negatives outweigh the positives and that measure tables simply aren’t that intuitive. In Power BI, measure tables are used to contain all

Power BI

Power BI Map Visualizations: Esri ArcGIS vs. Mapbox

Creating a map visualization in Power BI to display location data is not difficult. Power BI ships with a couple of different options available out of the box, and more can be added through the visuals store. Out of the box options include a native map, a “Filled Map” and

Power BI

Fact vs. Dimension Tables in Power BI

Figuring out the difference between fact and dimension tables in Power BI can be complicated. In this blog post we’ll go over the difference between the two and when they should be used. When you are building a data model fact and dimension tables are the two types of tables

SharePoint

Common SharePoint Intranet Requirements

Gone are the old days when SharePoint was positioned as a platform to build whatever you want. Microsoft is continuously repositioning SharePoint within its Office 365 suite to focus on what SharePoint does best. Functionality like document management, robust permissions, and easily customizable SharePoint pages is Microsoft’s future focus for

How To

How To: Get Longitude and Latitude via Power Automate

A little while ago, a client came through with a list of 400 addresses that they wanted displayed in a map visual in Power BI based on specific criteria. Unfortunately, in order to display the addresses in the way that the client wanted the map visual required us to get

How To

PowerApps Dynamic Navigation Tutorial – Part 1

Canvas PowerApps Navigation As app makers create more complex PowerApps, the need to navigate a user across the various screens in the app becomes a necessity. A lot can be taken from the web design world in how we can provide this experience. Two common patterns that we can take

Power BI

Benefits of Variables in Power BI

Variables in Power BI can be a very powerful way to enhance your DAX expressions and expand the possibilities of what DAX can do. Before Power BI supported variables, needing to use CALCULATE and the EARLIER function were cumbersome and created difficulties for data modelers. Today, those difficulties can be

How To

How To: Implement Conditional Navigation in Power BI

The pagination options in Power BI are a great way to break your Power BI reports down into manageable bites. Adding more pages can give a designer more real estate to work with and more ways to break down data. On the flip side, too many pages makes the Pages

Business Process

4 Easy Ways to Get Started With PowerApps

PowerApp applications are a blank canvas that can be used to accommodate almost any business use case. Featuring deep integration into the rest of the Office 365 suite and the Power Platform, PowerApps are a great tool in the intelligent enterprise’s arsenal. Whether the PowerApp is a canvas app or

Power BI

Power BI Pro vs. Premium

Along with the free license, Power BI offers a couple of different licensing options. The main license types to worry about are called Premium and Pro. Which license you need largely depends on the audience that you need to present your data to. Power BI Premium is heavily geared towards

Power BI

Date Tables in Power BI

For many entry level Power BI developers, using the built in date table in Power BI will work fine. Behind the scenes Power BI auto creates a date table based on the date values in your data. However, many experienced Power BI developers want more control over their date tables

How To

How to Add a Power BI Bookmark

Bookmarks in Power BI are a great way to create powerful reports and have a little more control over how the user interacts with your report. Essentially, creating a bookmark captures the Power BI report in exactly the configuration and layout that it was when the bookmark was added. Once

Guides

Office 365 Excel – Sheet View Feature

Fighting Over the Excel Filter A new feature that we’ve started to heavily use here at Kumo Partners is the Sheet View feature in Excel. This appeared to us at the perfect time as we utilize excel files embedded in Teams to track various types of tasks. As we use

How To

How To: Enable Preview Features in Power BI

Power BI releases new updates frequently, and sometimes those updates are only available as a preview feature. In other words, the feature is not ready for complete release but it will work in most situations. This blog post will detail how top check for and enable preview features in Power

Data Matrix Visualization - Image sourced from Microsoft
Power BI

Table vs. Matrix Visualizations in Power BI

At first glance the Table and Matrix visualizations in Power BI look similar. Both display data in a table format that reminds the user of Excel. However, understanding the difference between the Table and Matrix visualizations in Power BI is important to displaying data efficiently. The basic difference is that

Microsoft

Use Flow to Automatically Refresh a Power BI Dataset

Power BI’s existing data refresh schedules are limited and remembering to manually trigger a Power BI refresh can be difficult. One of the benefits of Power BI is receiving real time data, and Microsoft took steps to enhance this benefit by adding an action in Flow to automatically trigger a

Office 365

Multi-Line Field History Log in PowerApps

Introduction Hello and welcome to the first in the PowerApps Tips & Tricks Series! We have been working with PowerApps since the initial Beta Release in 2016 and have seen a lot of good and bad practices that have come about as the platform has grown. In this series, we plan

Stay In The Loop
Stay in the loop as we release more content and continue to expand our portfolio and service offering.