Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sundayDriver
Employee
Employee

Slicer for getting data

Hi,

I wanted to first say that power BI is an awesome tool that everyone in the team highly enjoys!

I wanted to ask the following question:

Our team has been running into the following problem:

We have the same data (that is too much for power BI to load) and we want to use the same report for them.

Same way as you can create a slicer that contains which data to be displayed is there an easy way that you can configure where the data will be pulled from?

To give an example you might have a large chunk of data of type blue, green and yellow.

Is there a way that we can on the fly select blue, green or yellow and get the appropriate data as we can't load data for all the categories?

2 ACCEPTED SOLUTIONS
Phil_Seamark
Employee
Employee

Hi @sundayDriver,

 

The limit for PBIX files is currently 1GB.  Power BI uses compression that can compress up to around 10x so is your source data really around 10GB?  

 

There are some tricks to reduce the import file size such as

  • remove unnessary columns,
  • aggregate your data in your source data if possible
  • Split Datetime data into 2 columns (if time is needed)

If these don't help then sure, DirectQuery is an option but hopefully your source system is SQL2016 with columnstore indexes optimised to the max 🙂

 

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

v-sihou-msft
Employee
Employee

@sundayDriver

 

As @Phil_Seamark and @Greg_Deckler, for large amount of data, you'd better use DirectQuery mode due to the 1 GB limitation. If you need to filter expected records (blue, green or yellow) during data retrieval, you need to do it in your query.

 

Regards,

View solution in original post

3 REPLIES 3
v-sihou-msft
Employee
Employee

@sundayDriver

 

As @Phil_Seamark and @Greg_Deckler, for large amount of data, you'd better use DirectQuery mode due to the 1 GB limitation. If you need to filter expected records (blue, green or yellow) during data retrieval, you need to do it in your query.

 

Regards,

Phil_Seamark
Employee
Employee

Hi @sundayDriver,

 

The limit for PBIX files is currently 1GB.  Power BI uses compression that can compress up to around 10x so is your source data really around 10GB?  

 

There are some tricks to reduce the import file size such as

  • remove unnessary columns,
  • aggregate your data in your source data if possible
  • Split Datetime data into 2 columns (if time is needed)

If these don't help then sure, DirectQuery is an option but hopefully your source system is SQL2016 with columnstore indexes optimised to the max 🙂

 

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Greg_Deckler
Super User
Super User

You would want to look at using DirectQuery.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.