Can't decrease PBI dataset size below 1 GB

[Anonymous]

I have 1 PBI report, which hit 1 GB. I split it into 2 reports: The first 1 is 250 MB, but the 2nd one keeps hitting 1 GB. I deleted several reports and queries with no change to the dataset. Any suggestions on why dataset size is not decreasing? 

[Anonymous]

All,

Thank you for the suggestions!

I even removed more queries and left only 4 active queries pulling records from 200 MB excel file with 4 tabs, which then are appended into a 5th query with few additional columns added for date formatiing. I have 3 slicers, 2 column charts and 2 tables with 4 columns each. Deleted all fields in the 2 excel tabs so literally there are only 2 queries pulling from the dataset now. Dataset size is not decreasing at all. 

@GilbertQ could you please share more details about star schema vs big table.

[wzkoral]

Try to find unnneded data and filter inoput table in Querry for example if you have 4 years sale , make just two left and then try.

[Anonymous]

Deleted data from 2 tabs in the excel, which contribute to 1 year worth of data for 2 measures - no change in pbix size.

[GilbertQ]

Hi there

How many tables do you have in your model?

It would appear that you might have multiple tables that are not needed.

Here is a quick detail on what a star schema is and how it works https://data-warehouses.net/glossary/dimensionalmodel.html

[GilbertQ]

make sure to remove all columns that are not needed in your dataset.

Also make sure to use a star schema and NOT one big table. The one big table will take up a lot more space. As well as not being efficient for DAX queries against the data model.

You can also use DAX Studio and see which columns are taking up the most space. Here is a blog post explaining how to do this: https://www.sqlbi.com/blog/marco/2019/09/15/vertipaq-analyzer-2-0-preview-1/

[Anonymous]

Hey @Anonymous 

We will likely need more to go on than that. Can you share the files or give examples of what the primary querries are pulling?

My only thought, assuming you kept a version of the original file, is to go back to that and work from there.