Powerautomate / sharepoint folder / new item

[artp]

Hi everyone 

I have a problem with mix of this three aplication/services:
1. Eveyday I recive mail with excel where is some data, Powerautomate saves this files on Sharepoint folder and this works great
2. I take all files from this folder using PowerQuery and use it in PowerBI

So where is my problem: always when Powerautomate flow saves files in Sharepoint folder new file is marked as 'New Item' and this make sens

but for Powerquery it's a problem becasue for example tool see 10 files as table type in this Sharepoint folder but the New Item is seen as 'Error'. Print screen below:

What is intresting - when I go to the sharepoint folder and just open and close last saved files 'New Item' Powerquery starts to see this file as a table not error. 

Do you have any idea what is an issue and how I can resolve my problem? 

[artp]

Hi, thanks a lot for your help. For my model I needed all files in this folder so content column 'Binary' was not useful. 

But I have found solution and reason why PowerQuery saw this Excel file as 'Error' (before manually open). And the issue are empty cels in first row of dataset:

As you can see cels C1, D1, (...) are empty so Power query saw only column A and B. At this moment my solution is: I created new flow with opens this file and create table range row 6 and all data below. This helped because all data is visible. 

I am not expirenced well but from your perspective is it a casual case that empty cells in Excel can be a issue for Power Query? 🙂

[lbendlin]

Every time source data is provided by humans (especially Excel) you have to expect things like this to happen and harden your code accordingly.

[lbendlin]

It may be a bug, but is it a problem?  All you need is the Content column.