Forum Discussion

tchristy99's avatar
tchristy99
Icon for Helper II rankHelper II
5 years ago

Splitting Query at null rows

I have excel files that are being dropped into a folder weekly. I am trying to use BI to pull them into a report, I don't have the ability to edit them before hand though. The stucture of these file ...
Need Help
negi007's avatar
negi007
Icon for Community Champion rankCommunity Champion
5 years ago

tchristy99 have you tried using remove rows and keep rows option. those option may help you in acheving the output that you are looking for. 

 

 

If above does not help you, can you share the screenshot of the final output basis the input data that you have shared above. thanks

tchristy99's avatar
tchristy99
Icon for Helper II rankHelper II
5 years ago

Hi, 

 

Thanks for your quick response.

 

 

That won't work because the amount of rows changes from file to file. Above is a image of the data (with a lot of rows hidden). What i need is them in 3 different tables in Power BI.