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  
Need Help
Tips and Tricks
amanda_puga's avatar
amanda_puga
New Member
1 year ago

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
    Icon for Super User rankSuper User
    1 year ago

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