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
Prajakta11
Helper IV
Helper IV

large Excel file issue

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 

4 REPLIES 4
Greg_Deckler
Super User
Super User

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


@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

@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

 

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


@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.