Forum Discussion
Power BI Connecting to a Folder containing spreadsheets
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!
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
.
3 Replies
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
.
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.
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
