Forum Discussion

josephliverpool's avatar
josephliverpool
Frequent Visitor
1 year ago
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...
Need Help
Show and Tell
Tutorial Requests
  • Omid_Motamedise's avatar
    Omid_Motamedise
    1 year ago

    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

     

     

     

    .

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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