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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Long Time to Import Excel data

Only 208K rows x 106 columns...took over an hour to import. Is it better to have source file open or closed while importing? Is there a way to copy and paste all at once in like 2 seconds like we can do in excel? Power BI is saying I have to parse into 3000 row increments?? I thought Power BI was designed for millions of rows?

2 REPLIES 2
v-stephen-msft
Community Support
Community Support

Hi @Anonymous ,

 

You don't have to make the source file open when importing.

Importing data does take time. The length of time can also be caused by different factors.

There's a optimization about data model for your reference:

Data reduction techniques for Import modeling - Power BI | Microsoft Learn

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

lbendlin
Super User
Super User

Yes, Power BI has no problem with long tables. What it absolutely does not like are wide tables. 106 columns is considered very wide.  But it also depends on the type of column, the cardinality, the column width etc.

 

Are you only importing or doing transforms?  What Excel format is it, xls or xlsx ?  Would you be able to provide a sample file?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.