Transform data button disable at power query (HELP)

[swilliam]

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

[amanda_puga]

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]

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

[Anonymous]

Hi @swilliam ,
Based on your description, we can't tell if Transform data is not working on power bi or excel. Can you provide the platform and version number you are using so that we can help you faster.

About Power Query in Excel - Microsoft Support
Query overview in Power BI Desktop - Power BI | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin]

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?