Forum Discussion
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
- lbendlinSuper User
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?
- AnonymousNot applicable
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 LearnBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- amanda_pugaNew Member
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
- lbendlinSuper User
you need to select a sheet or table. the checkbox must be checked.