Forum Discussion
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 ...
Hi tchristy99 ,
You can try to convert them into tables in Excel first, so that three tables will appear when you import Power BI.
Select the table you want and press Ctrl+T to generate the table. .
Then you can directly get the two tables when importing Excel.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for your response. I did consider that, but these files are being dropped in daily, so I need something on the BI side. It is very possible that its not possible.