Power BI Connecting to a Folder containing spreadsheets

[josephliverpool]

Hi!

I have connected to a folder in Power BI which contains spreadsheets, these are updated every hour automatically and the gateway automatically adds these spreadsheets to my dataset.

The only problem is that between 1 and 4 am, the spreadsheets are blank so they don't have any headers at all so it is crashing my dashboard.

In Power Query, is there anyway to remove the spreadsheets that are blank? I was thinking that this could potentially be based on row count perhaps? As in anything with row count > 0?

I just have no idea how to implement this!

[Anonymous]

Hi @josephliverpool 

Did the solution Omid_Motamedise  and lbendlin  offered help you solve the problem, if them help, you can consider to accept them as solutions so that more users can refer to.

Best Regards!

Yolo Zhu

[Omid_Motamedise · Accepted solution]

Yes and Table.IsEmpthy can be used.

Consider the next example inclucing two blank source and 1 non blank.

you can add a new column by the next formula

Table.IsEmpty([Data])

to reach tru and false for empthy tables then filtter the empthy one

.

[lbendlin]

yes, that sounds like a viable approach.  You can also consider trying to read the sheet and in case of failure return an empty table instead (can be a single column).

Read about try ... otherwise ...

Show your Power Query code if you like more assistance.