Power Query Question

[sla16310]

I have an excel file with 70000 rows of data that I am trying to import into my query. why is it taking so long for the data to finis

[Fowmy · Accepted solution]

@sla16310 

It could be due to multiple reasons:

• Check the applied transformations, if they are complex.
• .xlsx takes a lot of time, CSV works better.
• Makesure your data is in an Excel Table, if not insert a table in Excel. 
• Remove unsed rows and columns.
• Remove unnecessary columns, bring in only the columns needed.
  
  
  
  

[Anonymous]

Hi @sla16310,

Thank you for reaching out to Microsoft Fabric Community Forum.

Thankyou @ZhangKun  @Fowmy For addressing the issue.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,

Vinay Pabbu

[sla16310]

Sorry. I need to return to this site more often. I just did a reboot and that seemed to work. There was a data issue that I had to troubleshoot. Thanks for following up.

[Anonymous]

Hi @sla16310,

Thank you for confirming that your issue is resolved. Please consider accepting it as a solution so that other community members can find it more quickly.

Regards,

Vinay Pabbu

[Omid_Motamedise]

What is the steps of your query?

[ZhangKun · Accepted solution]

There are usually two situations:

The first is that the calculation is too complicated, which is more common.

The second is the wrong data range. For some unknown reason, the data range of the worksheet will be mistakenly marked as all rows. You can press Ctrl+End in the worksheet to check where the data range is. If it does not meet your expectations (exceeds the actual range), just delete the entire row or column.

[Fowmy · Accepted solution]

@sla16310 

It could be due to multiple reasons:

• Check the applied transformations, if they are complex.
• .xlsx takes a lot of time, CSV works better.
• Makesure your data is in an Excel Table, if not insert a table in Excel. 
• Remove unsed rows and columns.
• Remove unnecessary columns, bring in only the columns needed.