Forum Discussion

poinfrettia's avatar
poinfrettia
Frequent Visitor
1 year ago
Solved

Excel import not consistently recognising blank first column

Hi there, I have a Gen 2 Flow which imports lots of identical excel workbooks in a folder. Column A in all of them is blank - but I'm getting errors as sometimes the Gen 2 Flow imports this first bla...
dataflow
  • poinfrettia's avatar
    poinfrettia
    1 year ago

    Thanks - I tried setting InferSheetDimensions to false but you're right it still uses excel's used range. I don't have control over the file creation unfortunately but I can interfere if a file is recieved and breaks the flow. A bit faffy - hopefully a feature to control the import is added soon. Thanks! 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi poinfrettia ,

 

Thank you for reaching out to Microsoft Fabric Community Forum.

miguel Thank you for your quick response.

 

poinfrettia Yes, you're  right. Could you please try the below M code after

We can explicitly define the range of data in Advanced Editor in View tab.

 

After the Navigation step in M code, you can define the columns as below:

 #"Selected Columns" = Table.SelectColumns(#"Navigation 1", {"Column1", "Column2"}),  // Replace with actual column names

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos " – I’d truly appreciate it!

 

Regards,

B Manikanteswara Reddy

  • poinfrettia's avatar
    poinfrettia
    Frequent Visitor
    1 year ago

    Hi and thanks for replying - I've added more details to Miguel's reply which will hopefully clarify the problem better.