Power BI

I demo how to convert a Canvas App Color value to a Hex Color code

It is well documented how to save the contents of a multi-select combo box to a Single Line of Text field, but not so how to successfully get the

Pay-as-you-go for Power Apps is a new way to pay for Power Apps using an Azure subscription. Pay-as-you-go allows you to share a Power Apps app with any user in your organization and then only pay if and when they use that app.

This blog will show you step-by-step directions on how to get started with Power BI reports and Dynamics 365 Marketing.

Learn what is Power Automate Do until, what are the conditions available in it. Also, we will see all the limitations, counts, timeout settings, etc. in Power Automate do until action.

When you use child flows, you might need to collect the flow runs of your failed child flows to identify any issues. In this post some error handling tips.

Using the bookmark navigator, I will show you how to let your users choose what is displayed on the tooltip according to their preferences. By using this approach, you are able to switch easily between different tooltip pages without having to create multiple tooltip report pages SUBSCRIBE AND WATC...

Today, we’re happy to announce significant performance improvements to backup and restore operations for datasets in Power BI. Our benchmark tests with 1GB, 5GB, and 10GB datasets show backups can now be completed up to 22 times faster than before, and the time required for restore operations can also be reduced by more than 30%.

This article originally appears on the AvePoint blog as How to Get Started With Dataverse Solutions. Dataverse is sometimes viewed as a database service, but it’s much more than just tables and vie…

Power Apps math functions have a lot in common with Microsoft Excel. Many of the core functions like SUM and COUNT are exactly the same.

In this blog we will cover how to remove characters from strings using Regex in Power Apps. You can remove characters even as you type!

Introduction: In Power Automate, at times we need to write expressions manually, a quick way of doing is by using Peek code functionality that is present in every action in Power Automate . Especia…

BigQuery team recently released a fantastic new functionality, when using BI engine, all the statistics are saved in the INFORMATION_SCHEMA. When using BI Engine one major pain was it was not very …

This is a Bank App UI built with Power Apps using few HTML text and Power Fx.     HTML Text view   Download the package below for new environment setup.

I’ve come across many charts like this in the wild. They’re not bad charts, they serve a purpose, but they could be better.  Bar charts are created by encoding data by length. It is commonly thought that when people read bars, they are comparing length, not position. The axis starts at 50%, rather than zero,… Continue reading Thinking about target bands

Description will go into a meta tag in head /

OData has been adopted by many software solutions and has been around for many years. Most solutions are using the OData is to serve their transactional processes. But as we know, Power BI is an analytical solution that can fetch hundreds of thousands (or millions) rows of data in a single table. So, obviously, OData … Continue reading Optimising OData Refresh Performance in Power Query for Power BI and Excel

In the Power BI service, you can easily look at refresh times for an individual dataset or dataflow. There are many different reasons why these metrics are important to you as a dataset or dataflow…

Last year, we announced the public preview of Power Apps Ideas, which enables Power Apps makers to take advantage of Microsoft AI technologies that make it easy to write Power Fx formulas with no-code. In this article, we’re going to go behind the scenes to share what it took for the Power Apps engineering team to implement Power Apps Ideas and unveil some of the complexity that’s happening under the covers to support this user experience.

Click to run this interactive environment. From the Binder Project: Reproducible, sharable, interactive computing environments.

What are orphaned Power BI Workspaces and how do you get rid of them? What if you have a lot of them? Adam walks through some options including a PowerShell script! Delete Group/Workspace API: https://docs.microsoft.com/rest/api/power-bi/groups/delete-group AddUserAsAdmin API https://docs.microsoft.com/rest/api/power-bi/admin/groups-add-user-as-admin Power BI PowerShell CMDLETs https://docs.microsoft.com/powershell/power-bi/overview?view=powerbi-ps PowerShell Script: https://github.com/itsnotaboutthecell/PowerBI-cmdlets/blob/master/notebooks/PowerBI_Delete_Orphan_WS.ps1

In this session, Krish will show you how you can use Power BI to easily create 'real' real-time scenarios using Streaming Dataflows.

Kanban Board in Power Apps: Step 1 Create a SP list using the Microsoft List template "Work progress tracker" with the following name: Work

Recently we saw File usage for one of the environments reaching around 68 GB. We managed to bring it down to around 10 GB or so by (Microsoft Support quickly helped us by sharing the required detai…

Introduction Microsoft introduced Customer Voice in 2020 to get feedback from customers and save it into Customer voice entities in Dynamics 365 CRM. Further, they also introduced new features in  Customer voice. Recently, I was setting up Customer Voice and creating its invitations using Power Au

How would you call going from 380 tables in 18 Excel sheets, to one table on a single report page in Power BI?! Magic? Miracle? Check how Calculation Groups can help you to achieve (im)possible!

Hybrid Tables are an incredibly powerful feature in Power BI. But what if you wanted to create them outside of Power BI Desktop? Patrick shows you how you can do just that in Tabular Editor! –This Year let Source = Sql.Databases(“servername”), AdventureWorksDW = Source{[Name=”databasename”]}[Data], internetsales = AdventureWorksDW{[Schema=”dbo”,Item=”pbi_InternetSales”]}[Data], thisyear = Table.SelectRows(internetsales, each Date.IsInCurrentYear([OrderDate])) in thisyear –Last […]

If you are looking for the conditional formatting in the new #PowerBI formatting pane, I show you where to find it!

Switch Power BI chart axis dimensions to get data grouped by dates, weeks, months, or any other way that you want.