Power BI

Premise Excel files are one of the most common entities for data storage. In this post I’ll demonstrate how to parse Excel file in Power Automate and read each row. This post will be divided …

This PowerApps Component Framework (PCF) component includes a textbox that allows entering and validating international telephone numbers.

This post is all about how you can share Power Apps canvas apps with people who are external to your company. First of all, there are two main concepts that it’s important to understand. There is …

Want to set lookup fields with Power Platform dataflow in order to import related records into the Common Data Service? This post explains how it's done.

This page provides a list of URLs to help individuals get up and running with Power Apps and the Power Platform by putting together a list of helpful resources. This links can provide useful resour…

Let's look at how we can layout the Forms Pro survey entity in a different way using rollup and calculated fields and create a survey summary form.

<p>In this blog post, we will see how one can use various out-of-box Power Platform capabilities to build a flexible control to render a business process flow within a Canvas app. We’ve also included a pre-built solution as a sample implementation. The solution leverages Canvas Components, Common Data Service APIs via a custom connector and flows to build a re-usable component that can be used with any business process flow.</p>

<p>AppSource checker is now available in ISV Studio (public preview), helping make the certification process faster and more efficient. AppSource checker allows an ISV to check against the AppSource certification criteria of an app prior to submitting for AppSource certification. </p>

<p>Embed testing in your application life-cycle by automatically running your canvas tests from your Azure DevOps build and release pipelines.</p>

<p>In this post we look at how the Microsoft Worldwide Global Sales and Marketing Operations organization (WW GSMO) used the Power Platform to digitally transform the account planning process for thousands of enterprise accounts covering an annual $80+ billion book of business. The solution uses Power Apps, Power Automate, Power BI, Common Data Service, Azure SQL, Office 365, Microsoft Stream, LinkedIn, Dynamics 365 and Azure workloads.</p>

<p>An improved experience to create and manage authentication settings and identity provider configuration for portals </p>

<p>Power Apps portals support additional entities in global search</p>

<p>This feature provides simplified themes in portals Studio. Portal makers can use themes for common website properties using a simple and easy configuration experience.</p>

<p>Power Apps portals 2020 Release Wave I </p>

The Accounting and Finance community deals with high volumes of sensitive and confidential information. As such, reporting which enables everyone within an organisation to see only the information they are authorised to see is of importance to this community. Leveraging the Row Level Security and ...

When you have a tool that can carry out up to 380 data transformations, mostly through simple GUI clicks, then the tool is not ordinary. That explains why Power Query, originally born in Excel, is now a powerful engine in many other tools (Power BI, Power Automate, CDS, Azure Analysis Services, ma...

Theory If you just want to see read/write XMLA endpoints in action, skip to the Practice session. Otherwise, if you never heard of it or just wanna read up on the specifics, keep reading here and we'll get there eventually Preview Feature To start with a side-note disclaimer: XMLA Endpoint If ...

For someone utterly new to Power BI, and especially for those who have been using Excel, understanding DAX can be an overwhelming experience. At least, it was for me. It took me some time to grasp the concepts, filter and row contexts, and the CALCULATE function. One of the standard requirement...

Objective: We would like to have WTD(Week Till Date) Last WTD and This Week vs Last Week. Dataset: We have taken Sales data. The data is from April 2018 till April 2020. We have created a date Calendar. Steps: We create a Date Calendar With Monday to Sunday Week, with the following week-related...

We’re pleased to announce the first Monkey Tools update is now available! A new feature, some new logic and an update to our Power BI connector.

Slabs or tired calculations are common in income taxes or commission rates. Learn to do slab or tried calculations using DAX in Power BI

Utilizing Power Query Lists 2/3 This article is part 2 of the Using Power Query lists series. In this series, we will look at how we can use lists to do the following: Dynamic Filtering on a Column Using Lists Changing a Table of Attributes and Values to retain only Top 10 Attributes (by values) […]

Power BI incremental refresh is a very powerful feature and now it’s available in Shared capacity (not just Premium) everyone can use it. It’s designed for scenarios where you have a da…

In my last post I showed how to create a Power Automate custom connector for the new endpoints in the Power BI REST API for exporting a report to a file. In this post I’ll show you how to use…

Recently, a new set of endpoints in the Power BI REST API for exporting Power BI reports and paginated reports to files went into public preview (see the main announcement here and the paginated re…

Companies are generating an amazing amount of data, but do they know how to use it? Often, the answer is ‘not really.’ You need to leverage a solution that can help your employees understand what your data is telling them. With Microsoft Power BI, you have access to manipulate, learn from and act on your […]