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 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
.