TRANSFORM DATA AND LOAD

[FRASER]

I am new to the Power Bi, I've imported an excel, but both load and transform data buttons are not enabled so I cannot move forward only canel is an option? why is this abd how do I enable?

[pietryga]

Hi, I am new to to Power Bi, I am facing an issue that I can not tranform my whole data. I want to transform an excel file, unfortunately is not reading mine sheets, just some 'printareas'which doesn't contain all rows and all data.

eg 

[FRASER]

thanks I've right clicked and selected tranform and it's worked 

[FRASER]

[AbbasG]

select the sheet that you want to load and then you will see the options

[AbbasG · Accepted solution]

@FRASER can you share the screenshot of what you see??