Pbix file size increases on making a change in the source query (lesser data pulled in)

[vanessa]

I have .pbix file which was around 61MB in size.

I made a small change in pulling data from a particular table. Earlier the entire table was being pulled, now I updated the MQuery for the same by adding a where clause. Due to this, the amount of data being pulled into Power BI has been reduced by around 20k rows.

But on savng thre report, I see that the file size is now around 85Mb. 

What could be the reason for this?

[harshvchawla]

I have a similar problem.

I now use where clause to import mysql data into powerbi, limiting data pulled each day to 90 days in a rolling fashion (only pull data for "last 90 days").

Still, as seen in powerbi service, the size of the report keeps increasing daily at a contant rate (say about 5MB per day).

Should not the report size be almost constant instead of growing now? The number of rows being pulled daily in are almost same too as measured from the queries.

Does powerbi service keep accumulating data in its query cache and never purge it?

[eniX]

I agree, it's difficult to say with such little information. One possibility I can think about is the fact that data is stored column-oriented. Thus, the size of the .pbix-file is not directly correlated to the amount of the rows. it's rather correlated to the amount of different values in your data: if your data suddently contains much more variety in values, it is possible your .pbix-file size increases.

[Greg_Deckler]

Hmm, are you sure you didn't pull that into a separate table? Tough to really say what is going on with that amount of information.

[vanessa]

@Greg_Deckler @eniX

Yes, I am sure. I just changed the query in the advanced editor for that table. Earlier I was pulling the entire table without the SQL statement. Now I included the query with the where clause in the advanced editor. Also, I reduced the number of columns being pulled in.

[Greg_Deckler]

What happens if you create a brand new PBIX file and copy and paste the Advanced Editor code into the query, what do you end up with?

[vanessa]

I guess it was some bug. I closed and opened the file again and the file size is now 61Mb.