Power BI

Recently while working on a consulting project, I came across a very interesting problem. It was interesting enough, that I am passing it on to you.   Consider this Employee Data The data represents an employee role for each month, since the employee’s joining date. Each row means 1 employee assigned to a certain role [...]

Unfortunately, it does happen… You have just added a new calculation group/calculation item to your model and all of the sudden, some of the visuals on your report stop working. Usually, the main r…

In this article I will show you how to hide passwords in Power Automate flow by using Azure Key Vault and securing flow inputs and outputs.

I was inspired reading Alex Shlega and Hiroaki Nagao ’s posts on using code with custom connections. So I set out to give it a go and work on another common problem I have: Parse CSV First a picture showing you how it works.

From productivity apps that drive collaboration to mission-critical solutions, organizations are deploying Power Apps as a low-code application development platform to automate processes, modernize legacy apps, and solve business problems at scale.

Welcome to Power Platform Weekly!Last week Public Preview of a new feature under Power Apps Ideas was announced, programming by example, generating Power Fx Formulas from example. We also got two new Public Previews related to Power BI, a new Admin API to determine who has access to what as well as the Insights feature.The Community has played around with in-app notifications. See the Articles section! Last week there was also an announcement  from Ivan Ficko, who has created a new tool In-App No

item at specified position in collection in power apps canvas apps.

Replace values in Power Query is easy. Things get more complicated once you add conditions, on multiple columns, needed case-insensitive...

What is the Pivot Columns operation in Power Query? And how can you use it to pivot text values and numbers? Follow along to find out!

To understand how a filter can affect performance, first we need to understand what a filter is. A filter is a temporary table that is created on demand, held in memory, and then used as a reference for the function being filtered. The rows of the temporary filter table are all DISTINCT. This is because […]

I decided to stop writing book reviews here on my blog a long time ago: it’s a lot of work to read a book and write a proper, detailed review and what’s more I don’t like the idea…

Scenario: Suppose I have many columns which both column names and fields look untidy.  I want to do some transformations for them in batches. For example, replace multiple spaces as single space and uppercase each first character of word so that the table would look neater.   Sample data: Expected ...

A new Admin API to determine user permissions

Learn how to add a year-month combination into the Power BI report using DAX and sort it correctly using an example.

Paradigm BI Posts - Paradigm BI and Active Business Intelligence Updates - We have released two paginated reports for our Planner Reporting solution.

Did you know that Power BI can automatically refresh your report page? Did you know there are two different types of auto refresh? Learn everything you need to know about this powerful feature!

This article describes how to customize the drillthrough experience in Excel PivotTables connected to Power BI datasets or Analysis Services databases. When

Very often I hear flow people telling others that we should use Compose actions instead of variables. But when you reference a compose action it just shows

Looking at new ways of Expressing Date and Time Values in Power BI DAX in order to more quickly do analysis with Date and Time.

Brand new Tabular Editor scripts to make your development in Power BI Blazing Fast. Read more about these performance scripts.

Learn a new way to implement a Power BI mobile experience. Mobile devices are a creative way to distribute Power BI Content.

Often I got the question from customers: “Can you assign my workspace to a premium capacity?” But frequently they actually do not really need Power BI Premium. It remains to be a diffic…

Implementing a Try, Catch , Finally pattern in Power Automate flow

[...]Read More...

ValQ is a Modern Visual Planning and Business Modeling Tool that helps enterprises run simulations, plans & analyses in a very visual and intuitive manner.

This article describes how management of the program was transformed to save time, and holistically track and monitor the program and drive actionable insights using Power Platform and Dynamics 365.

Error handling and TRY, CATCH, AND FINALLY are very important tasks in Programing as well in any kind of development & Microsoft Power Automate or Microsoft Flow is no different. Error handling and TRY, CATCH, AND FINALLY can be easily implemented in MICROSOFT POWER AUTOMATE/MICROSOFT FLOW for handling different different business scenarios. You can place … Continue reading Try, Catch, and Finally In Microsoft Power Automate/Microsoft Flow | Error Handling Using Scope →

A while back I write about a Try - Catch construction in Microsoft Flow. Within my Catch I then sent email with some limited information such as the title of