Power BI

What I wanted to do in this example is to show you how you can manage multiple dates in your Power BI tables. This is a very common issue I see that new Power BI users are experiencing with their development work. There's always a bit of confusion on how you actually set up the data model correctl...

Video by: Reid Havens Learn about a great technique when applying measure-based conditional formatting to visualizations in Power BI. This technique will help significantly reduce development time.

A few weeks back[1] I got this comment on my Power BI dataflows overview post: This morning I started to reply to the comment, and by the time I was done I realized that it should be a blog post on…

A recent engagement brought an interesting dilemma. An ISV wanted to embed Power BI reports in a SharePoint Online portal accessible by their customers. The app handles user authentication and authori…

Learn how to find overlapping time periods using #PowerQuery. In part 2 of this challenge you will learn step-by-step how to create the solution

Every once in a while, I come across a data warehouse where the data load uses a full truncate and reload pattern to populate a fact or dimension. While it may not be the end of the world for a small …

By In this article, I want to show you how I achieved a business solution using DAX. Let me explain the requirement. I have a below table and customer wants the data in the below format. Country Color…

Tuesday July 16 2019, I presented my webinar Storytelling and interactive reporting with Power BI bookmarks and drillthough as part of the webinar series "Best of Power Platform Summit." My first webi…

The first out of seven blogs, as part of my blog series regarding Storytelling with Power BI. During this blog series, I will elaborate on seven topic which can be used to apply storytelling features …

This article describes different techniques to display the first three products for each category in Power BI. It includes considerations on how to adapt th

I was having a discussion earlier this week about the use of variables I used in my currency conversion blog post . The question was why I am using 2...

A quick blog post to show that the new Power BI look and feel report page size is actually bigger than the older version.

The recording of Uhms and Bunny Hands: Tips for Improving Your Presentation Skills (from DataGrillen 2019) is now available on YouTube!

Like many things in Power BI, Power BI Tool Tips functionality evolved so much. I probably do a post on Tool Tips sometime soon. Today it’s about visual header tooltip.…

The Tip: Convert calculated columns in your model to physical columns (where practical). The Detail If you encounter memory issues when processing partitions in an Analysis Services (AS) database, …

Export data from visuals in Power BI has limitations that can be circumvented by a simple trick. Using DAX Studio with a automatically created query:

Shared datasets, as well as dataset endorsements which include certified and promoted datasets, are interrelated and can play an important role in a self-service BI implementation of Power BI.

I am so excited to be sharing the first edition of the Power Platform Adoption Framework, the start-to-finish approach for adopting Microsoft’s Power Platform at scale. The white paper is available at this link. My hope is that the framework will continue to become a worldwide standard for enterpris

We need to use Power Platform Adoption Framework as an opportunity to embrace the whole platform, which means thinking about all the component parts — Power BI, Flow, PowerApps (and Common Data Service!) — when we think about enterprise adoption.

Now that we have what I will call a mature and evolving platform, it’s time that the community around that platform get serious about meaningful best practices. We owe it to our customers, our employers, and one another to adhere to a shared commitment to excellence and a body of best practices that

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup146 Tech Video: https://guyinacu.be/detectdatachanges Sources Power BI Visual Header Tooltip (@pka…

A summary explaining the new look in Power BI Service

<p>One of the most common things people do when they start editing a PowerApp is right click and be disappointed to only find the browser menu. Well, no longer! We have updated the canvas to res…

This blog post is an introduction on how to use Version Control in Power BI Desktop to allow for the PBIX files to be automated

This month we are incredibly excited to announce that the new filter experience is now generally available. We have updated the look and feel and added a ton of new functionality. The new cap…

In July 2019 Power BI Desktop released the ability to Icons in Tables & Matrix visuals. Hit hit tutorial on how to use these icons and and custom ones.

With this month comes the first feature release from our announcements at Microsoft Business Application Summit, Icon sets, which also addresses our current #1 idea on ideas.powerbi.com. On t…

Learn how DB Best can help you optimize your environment and workloads after reaching the Power BI Premium resources limit.

<p>PowerApps Portals is a significant step towards empowering all PowerApps makers to create powerful low-code and responsive websites which allows users external to their organizations to inter…