Error with Close & Apply after uploading and transforming excel file in Power Query editor

[PBI_newuser1]

After selecting Close & Apply after uploading and transforming excel file in Power Query editor , I get message" There are pending changes in your queries that have'nt been applied" and dialogue box with "Something went wrong - requested value'( )' was not found" and "Load - Requested value not found". Please help. Thank you.

[Anonymous]

Hi @PBI_newuser1 

Looking at your error message, it seems that there is a value that has not been recognized, please check the value in your excel file .

How about loading the excel file directly in Desktop view ? You can have a try and then see if this data can be imported correctly .

Best Regard

Community Support Team _ Ailsa Tao

[PBI_newuser1 · Accepted solution]

Thanks for your response Ailsa. I was able to identify what the problem is and found a solution. The settings on my computer had to be changed for Region under the Windows Control panel from parenthesis ( ) to - for all fields.

[PBI_newuser1]

This is part of the long error message. Any help would be very much appreciated.

Feedback Type:

Frown (Error)

Error Message:

Requested value '( )1' was not found.

Stack Trace:

System.ArgumentException

   at System.Enum.TryParseEnum(Type enumType, String value, Boolean ignoreCase, EnumResult& parseResult)

   at System.Enum.Parse(Type enumType, String value, Boolean ignoreCase)

   at 

[amitchandak]

@PBI_newuser1 , you need to provide more information on operations

[PBI_newuser1]

I was in a training session using dummy data with Excel files. Please let me know what other type of information you need.