Online events

FPBIPT #64 - New ways to optimize shared datasets in the Power BI Service

Tuesday 20 February 2024

This event has finished.

Started 17:00 PM

Finished 18:00 PM

Organized by Fabric Power BI Portugal

Venue: Online/Virtual

Address: Online event on your device

See other Online events

Copy this link to share the event with anyone:

Share to social media:

About this event

In this session, we will take a look at a new approach to reduce the size and increase the performance of our Power BI datasets and reports.

We all know the best practice to only load columns we need into our data model. In theory, this makes perfect sense but in reality, it is hard to achieve. We can use external tools for Power BI however to identify which columns are used and which are unused. This will help us shrink our dataset while making sure nothing breaks down in our reports.

As soon as we enter the Power BI Service, things get more complicated. Many people could have built reports on a centralized (shared) dataset in our organization. It becomes too risky to remove anything from that. The result is that our Power BI tenant gets bloated and the data is just piling up.

Even for this there are solutions out there and we will look at an automated way to optimize these datasets as well. It is possible that more than 50% of the size of the dataset is not used anywhere but nobody knew about it.

In this session you will learn to harness external tools for Power BI to optimize and shrink the size of your datasets especially in the Power BI Service. We will be able to declutter things and make sure everything is nicely organized.

**About the speaker:**

### **[Gregor Brunner](**

Founder @

Working with Power BI for over 7 years

**About the event:**

* All presented times are **Lisbon Time**

* Meetup will be hosted in **English**

If you have any questions, please feel free to contact us at

This page last updated Sunday 18 February 2024 at 23:29.

Problems? Report an error or inappropriate listing here.

Information displayed here is provided in good faith but we are not responsible for the content of any listing. Sometimes events can be cancelled or changed at short notice. Please check with the venue or organizer before you travel!

Oh no. Javascript is switched off in your browser.
Some bits of this website may not work unless you switch it on.