Power BI

dataflow templates

The Quick Access Toolbar can be a handy shortcut menu to speed up your report writing. Read this article to learn how to customize the Quick Access Toolbar.

Every few weeks I see someone asking about using Analysis Services as a data source for Power BI dataflows. Every time I hear this, I cringe, and then include advice something like this[1] in my respo…

If you build software or data solutions[1] you have probably encountered one or both of these situations: You're trying to report a bug, but the developer doesn't believe that there's a problem. Someo…

This month the Power BI dataflows team announced an exciting new capability available in preview for dataflows in workspaces backed by Power BI Premium dedicated capacity[1]. This compute engine build…

It seems like everyone knows about how Power Query in Power BI Desktop lets you use web pages as data sources, and lets you build queries by entering values from the web page. This is probably because…

I'm not a data visualization professional, nor do I play one on TV. Even though I've been working with data professionally for over 20 years[1], I've generally been on the back end of systems, working…

When you build a Power BI dataflow, lineage is built in. It's not an added feature - it's a fundamental aspect of how dataflows work. Instead of having an ETL process that performs the data movement a…

With Power BI aggregations, organizations can perform petabyte-scale analytics with instant response times, exploring and analyzing trillions of rows of data and interactively extracting insights on the fly. Aggregations can dramatically reduce the cost of unlocking large datasets for decision making.

<p>In June the PowerApps team released over 16 new features and enhancements for making your application creation experience even more productive and fun. This blog post gives you the highlights…

This blog post details how to connect to Power BI Premium datasets using Excel. This allows users to directly connect to the Power BI Premium dataset.

I've had a few people ask me recently for advice on getting into business intelligence/analytics consulting. I have been in consulting for 6+ years and have worked for 3 different consulting firms, so…

As of this month Power BI finally supports filtering slicers down to only show rows that have fact data. Before the only thing you could do to achieve this was...

Video by: Reid Havens Learn how to implement some advanced DAX measure organization and sorting within Power BI. Including creating nested folders and putting one measure in two different folders .

We’re excited to announce we’ve started to roll-out the Viewer role for the new workspace experience, perfect for users who need to view content within workspaces without the ability to …

Imagine you are the owner of a local restaurant and you’ve had modest success with a marketing coupon campaign in the past. You sent out some coupons through the local mail and ended up noticing an uptick in business over the next few weeks. Now you’re wondering which customers you should target nex...

The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow. I find customers are confused on the use cases of these products and how they compare to other prod…

This blog post explains how to configure and use the new certified datasets feature that is available in Power BI to enable better use of datasets in Power BI

Performance optimization in Power BI can be complex. This posts purpose is to present simple design techniques to help prevent typical performance issues.

We are excited to announce new improvements to Power BI dataflows releasing this month including an enhanced compute engine to drastically improve data refresh times and a new set of dataflow…

Introduction In this article we will look at: Branding Creating Responsive Screens. Using Collections to standardize your UI. Other UI Design best practices, including using SharePoint list to configu…

If you use dataflows with Power BI Premium, you probably use linked and computed entities. There’s an overview post here, and an example of how to use these tools for data profiling here, but…

This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure. In this example, using CONCATENATEX helps iden

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup142 Tech Video: https://guyinacu.be/paginatedtips Sources Introducing Calculation Groups (@marcorus) Customer Stories sessions from MBAS 2019 (@SQLAllFather) Updated(!) Guide To Selecting Between Azure Analysis Services And Power BI Premium (@DaveRuijter) Introduction to Charticulator: Create Custom Visual – Part 1 (@leila_etaati) Announcing Bring Your Own …

Reading Time: 4 minutes An accordion for a user interface is a control that expands a relevant section when a user makes a selection and collapses other sections that are not in focus. Whether you use…

Power BI is constantly evolving - there's a new version of Power BI Desktop every month, and the Power BI service is updated every week. Many of the new capabilities in Power BI represent gradual refi…

Power BI is constantly evolving – there’s a new version of Power BI Desktop every month, and the Power BI service is updated every week. Many of the new capabilities in Power BI represent gradual refi…

In the previous article, I explained how you can build a data model for budget vs. actual, where the grain of the two fact tables is different. The model works perfectly as a star schema. As long as y…

Overview Below is an overview of some of the announcements and things that were not product specific. The first picture below is incredible in terms of seeing how big the Power Platform is. Particularly if you look at how Power BI ingests more than 20PB of data month, hosts more than 25 million data...