when I imported the excel file "data" to power bi it needed a lot of transformation in the power query and I tried but couldn't.

can you please provide a screenshot of the issue you are facing?

Follow this topic