Excel Table headers have Arabic, Listing rows with $select gives- "Term 'أرقام ثلاثيه D' is not valid in a $select or $expand expression."

[Moosa]

Hi Power Team,

I'm trying to get the only columns I need using Select Query option from excel online action (List rows present in a table).

In my case, I have Arabic text headers.

List rows with select query

But unfortunately, I get Bad Request error on this action.

How can I resolve this?

Thank you.

[Moosa · Accepted solution]

Okay so, after some trial & errors I just found that the Select query here is not accepting 'Spaces'.

It's not the Arabic text but space between them, I removed all spaces and it worked just fine.