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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
cpljdford866
New Member

.pbix excessively large for 5k row dataset

I've encountered an interesting challenge in a .pbix file where my SQL Server data connection seems to be pulling in far more data and/or metadata that isn't actually needed. 

 

I'm using the Advanced Options within the connection interface to inject raw SQL with limiting criteria and only necessary columns but despite this query only retrieving ~5k rows and 27 columns the .pbix file is almost 500MB in size and takes a considerable amount of time to publish to the PBI Service. 

 

I've taken the usual suggested steps on eliminating unnessessary columns and limiting query results as much as possible but this challenge persists. The only distinguishing characteristic of my dataset that I believe could be having an impact here is that many the columns are Date values, which the PBI SQL server connection seems to pull in some date hierarchy metadata on.

 

I would welcome any helpful suggestions or advice on how I can reduce the size of this dataset to allow for faster publishing and data refreshes!

1 ACCEPTED SOLUTION
dcrow5378
Helper III
Helper III

Have you tried turning off Time Intelligence, Auto date/time?
File > Options > Current File > Data Load > Time Intelligence > Uncheck Auto date/time.

dcrow5378_0-1661527766672.png

 

 

View solution in original post

3 REPLIES 3
dcrow5378
Helper III
Helper III

Have you tried turning off Time Intelligence, Auto date/time?
File > Options > Current File > Data Load > Time Intelligence > Uncheck Auto date/time.

dcrow5378_0-1661527766672.png

 

 

That did the trick! Thank you very much!

 

Strange that such a simple feature can cause the .pbix file size to increase by orders of magnitude. My file size is now ~500kb vs 500MB.

Nice!
Yeah, should probably come unchecked out of the box.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.