Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

large Excel file issue

‎03-13-2023 12:40 AM

Hello , my data source is excel ,file is around 200mb becaue of which i am facing a problem ,what is the work around for this ,please help 

Labels:
Message 1 of 5
630 Views
0
4 REPLIES 4
Greg_Deckler
Community Champion
Community Champion

‎03-13-2023 12:44 AM

@Anonymous What is the problem you are facing? Power BI should be able to ingest a 200MB Excel file. Are you getting an error?



Follow on LinkedIn
@ 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!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Message 2 of 5
627 Views
0
Anonymous
Not applicable
In response to Greg_Deckler

‎03-13-2023 12:50 AM

@Greg_Deckler  Thank you for your reply, i am not facing problem at power bi , the problem is data source file as it will keep on increasing and we have 4 to 5 calculates collumn ,i cannot open that excel file to load new data ,so to avoid that i wanted to change my data source if that works

 

Message 3 of 5
598 Views
0
Greg_Deckler
Community Champion
Community Champion
In response to Anonymous

‎03-13-2023 12:54 AM

@Anonymous Toss your data into SQL Server. Azure SQL DB's are cheap.



Follow on LinkedIn
@ 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!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Message 4 of 5
593 Views
0
Anonymous
Not applicable
In response to Greg_Deckler

‎03-13-2023 01:00 AM

@Greg_Deckler can you help me out how can I do that ??

 

Message 5 of 5
587 Views
0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All