Forum Discussion
Solved
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 o...
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.