Forum Discussion

swilliam's avatar
swilliam
New Member
1 year ago

Transform data button disable at power query (HELP)

Hi Fellows, 

 

I can load the excel file but can't transfrom data as the button is disable, how to fix it? 

 

Appreciate any tips/solutions.....Thanks

 

4 Replies

  • Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck? Is this on a Mac?

  • Hi, guys

     

    I'm facing the same problem.

     

    I'm using windows 11 and Power BI Desktop versio 2.137.1102.0.

     

    I've try impor an excel file but the options to load or transform the data are disabled.

     

    I opened the file in excel and is working without errors, so the problem is in the Power BI I think.

     

     

    Thanks

    • lbendlin's avatar
      lbendlin
      Super User

      you need to select a sheet or table. the checkbox must be checked.