Power BI

I have written another blog post about variables previously and explained how useful variables are. Variables in DAX are helpful in both readability and also the performance of your code. However, there are scenarios that you have to be careful when you use variables. Because variables are stored, they might return a result that is…

I have previously written about how to sort a column by another column, and I used Month Names as an example. However, still, many are unaware that the same technique with slight modifications can be applied to any other columns. You can have a text column in your slicer (product category for example), and sort…

We look at how you can sign up for Power BI without a work email. If all you have is a personal email, this video is for you!

The Community Portals template is a quick and easy way for a Power Apps organizations to get up and running with their own community portal. The template provides a lot of nice out of the box functionality, including blog posts, forums, and ideas. Let’s look at how to use the Community Portal Template in Power Apps Portals as we as how to add new content. First, go to https://make.powerapps.com/ and select … Continue reading Creating a Community Portal with Blogs, Forums, Ideas, and KB using Power Apps Portals

This article describes how to write efficient DAX expressions that compute the compound interest of incremental investments made throughout the holding peri

I have written another blog article previously about how to set up your Power BI to get data from a file in OneDrive for Business folder without needing gateway. That was a popular blog article, but I got questions about what if I want to get data from a folder in OneDrive for business but…

This morning I noticed a new setting on a new PowerApp that I created. Preload app for enhanced performance Allow users to download the app file while authentication is being completed. When you al…

Power Apps Portals are functionality that can be used by Dynamics 365 / Power Apps environments for quick, customizable out-of-the-box portals. These portals can provide many advantages for businesses, including giving customers round-the-clock self-service support and the ability to create their own cases online in a secure environment. There are a few types of portals that are currently available for organizations to take advantage of. These portals are: Community Portal Customer … Continue reading Help Your Customers with a Customer Self-Service Portal Using Power Apps Portals

This is a new post of the Bad Practices in Power BI series – This time we discuss the momentum of Power BI and what you can do about it (or fail to). In Power BI’s 4th birthday celebration, Arun Ulag, the general manager of the Power BI product team shared a stunning visual. On …

This webinar walks through how to make Custom Visuals with no Code. Learn how to use Charts.PowerBI.Tips to enhance your reports. Click here...

Easily copy your Power BI reports to other workspaces. Including your My Workspace! We walk through what you need to do to accomplish this.

The new Get-PowerBIActivityEvent has got some new columns which allow for better reporting insights which is shown in this blog post.

Yes! It is possible to use incremental refresh with files that are hosted in a folder either locally or in SharePoint. This article gives you the general pattern to carry it out.

The easiest way to get data from the new Power BI REST API Event Activity Log. It uses a Power BI Custom Connector with start and end date parameters to query the data from the API.

Well – creating measures in the Power BI desktop is usually doing a lot of copying and pasting of measures. And unfortunately, we haven’t yet gotten a Copy measure in the shortcut menu when w…

When designing your model you will in most cases need a date dimension and one of the things you always should do is set the Summarization of the number columns in your table to none instead of the…

Build out powerful Power BI custom themes

This article provides ways for you to monitor and optimize the performance of the on-premises data gateway activities.

From the day Microsoft made the "PowerBI - Refresh a dataset" Power Automate connector available, and having seen this video by GuyInACube https://guyinacube.com/2019/10/24/use-microsoft-flow-and-other-options-to-refresh...

I have written a dozen of blogs and a book about Power BI row-level security and the security on the dataset. However, I always get this question that: "What if I want some people to see only a few pages of my report, and some others to see other pages?" or "How can I put…

Tracing and diagnostics for Power Query can get you crucial information to troubleshoot problems in Power BI Desktop. Find out how!

It is normal for a power user to start working on one device & pick up where they left off on another. Hence the need to have responsiveness in PowerApps.

Reference information about configuring Height, Width, X, and Y properties on controls in canvas apps

Hello, when I navigate to a screen (say SCR1) for the first time, PowerApps shows the screen at its top position. If I scrolll down, go to another screen, and then come back to SCR1, it shows the screen at the last position used (so down part in that case). Whereas I would like it to always disp...

Step-by-step instructions for changing settings such as the screen size and the orientation of a canvas app in Power Apps

Learn how to use Power Automate to detect issues with your Power Query data refreshes in this hands on tutorial from PowerBI.Tips.