limiting rows in Power BI

Limiting Rows in Power BI when Creating Reporting for Big Data (Overcoming Memory Limits)

Are you working with more data than you can handle in Power BI Desktop on your machine? Work with the subset of data locally and all the data in the service without using Premium and overcome the memory limitations in the desktop application!

Watch the video below on limiting rows in Power BI in the desktop, for the step by step instructions and deeper explanation.

To summarize, Patrick is working with a data source that has 600k rows.  He adds a step in the query to keep top rows, then adds a parameter to trigger whether to bring in all rows, or a subset.  He then adds a line to utilize the parameter.  Patrick demonstrates the pull with the parameter set to A (all records), and then again using the S (subset) parameter, which pulls in only 100K records.

Patrick then publishes to the service while only having 100k records loaded and continues on to demonstrate how to change the parameter to A in the browser/published version.

He then manually kicks off the refresh in the service and once complete, shows us that all 600k rows have now been imported into the model.  Very cool and useful trick, especially when working with lots of data, especially Big Data!

Video and Tip Courtesy of Guy In A Cube:

http://twitter.com/guyinacube
http://twitter.com/awsaxton
http://twitter.com/patrickdba
http://www.facebook.com/guyinacube
https://www.instagram.com/guyinacube/
https://guyinacube.com

***Gear***
šŸ›  Check out their Tools page – https://guyinacube.com/tools/

#PowerBI #PowerQuery #GuyInACube

Can Patrick handle the challenge??? Query Folding in Power BI!

Can Patrick handle the challenge that Alex Powers presented to him? Can he actually complete the challenges of the Power Query 30 day Query Folding challenge? Let’s find out…

These are great for both Power BI and Microsoft Excel!

30 Day Challenge Continue reading “Can Patrick handle the challenge??? Query Folding in Power BI!”

Organize your DAX measures

How To Organize Your DAX Measures in Power BI Folders and Make Finding Them A Breeze

As you progress in Power BI, you will gradually be working with more DAX measures and calculations. As a result, things can easily get cluttered. Today you will learn a few valuable tips and tricks on how to organize your DAX measures for a more efficient workflow. Hopefully this will help you and become a standard practice!

Watch the video for step by step instructions and a full explanation.

To summarize, Reid shows us how to add a new table and move our measures to it so they are together in one place.

He then shows us how to convert this into a folder, and then subsequently create subfolders to further organize your DAX measures in the model. Reid continues on to show us how we can have a measure in multiple locations if it makes sense.

What a great way to manage the measures as they grow in number!

***** Video Details *****
00:00 Introduction
00:33 Root folders
01:32 Subfolders
03:30 Actual Amount VTB

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial

How Collaboration Can Produce Amazing Reporting Applications In Power BI

In this video, I want to showcase how collaboration can produce one of the most incredible reports Iā€™ve seen in Power BI. This particular work was created by a group of Enterprise DNA experts better known as ā€œJMAPā€, as their Continue reading “How Collaboration Can Produce Amazing Reporting Applications In Power BI”

Dynamically Subsetting Table Visuals In Power BI

Today, we do a deep dive into a question about how to dynamically subset table visuals in Power BI based on slicer values. Weā€™ll tap on a bunch of interesting elements including disconnected tables, slicer harvesting, slicer visualization tricks, virtual Continue reading “Dynamically Subsetting Table Visuals In Power BI”

Reports & Visualizations Pt. 2 – Power BI Best Practices Vol. 4

In this video, Iā€™ll continue discussing my best practices for reports and visualizations. This is Volume 4 of the mini series weā€™ve made about Power BI Best Practices. This particular volume is split into 2 parts. These are some of Continue reading “Reports & Visualizations Pt. 2 – Power BI Best Practices Vol. 4”

Top 10 Power BI Best Practices

Today, Iā€™m going to share my personal Top 10 Best Practices for Power BI. Over the past months, Iā€™ve released a series of videos showcasing a number of best practices addressing the 4 pillars in Power BI report development. I Continue reading “Top 10 Power BI Best Practices”

Free Power BI Resource Collection Including Dataset Builder Tool

For todayā€™s video, I wanted to spend some time highlighting a fantastic new free resource collection available to both Enterprise DNA members and non-members. Iā€™ll also be particularly demonstrating a tool called Data Randomizer, which can be used to build Continue reading “Free Power BI Resource Collection Including Dataset Builder Tool”

New Modern Visual Tooltips For Power BI

For todayā€™s video, Iā€™d like to talk about the new Modern Visual Tooltips released just yesterday. The May 2021 Power BI updates is not a hugely exciting update but the Modern Visual Tooltips in particular is a feature that I Continue reading “New Modern Visual Tooltips For Power BI”

Achieving Project Balance In Power BI – Problem Of The Week #11 Solution

Greg Philps leads Problem of the Week #11. A not-uncommon problem that almost every Power BI user experiences is maintaining project balance. A project expands in scope over time, and when one side of the ā€œProject Management Triangleā€ changes, at Continue reading “Achieving Project Balance In Power BI – Problem Of The Week #11 Solution”

Perpetual Holiday Calendar In Power BI – Problem Of The Week #12 (Power Query Solution)

You might be wondering, didnā€™t we create a Perpetual Holiday Calendar already?Ā And the answer is, yes we sure did! That was eDNAā€™s maiden POTW DAX Challenge and now we get to do it all over again using only Power Query/M Continue reading “Perpetual Holiday Calendar In Power BI – Problem Of The Week #12 (Power Query Solution)”

How To Simulate Dynamic Theming In Power BI Reports

In this tutorial, Iā€™d like to demonstrate how you can simulate dynamic theming in your Power BI reports. As of May 2021, only a single theme JSON file can be used in a Power BI report and a page can Continue reading “How To Simulate Dynamic Theming In Power BI Reports”