Forum Discussion
Column names with reserved keywords not being identified properly while importing data in PowerBI
While importing data I'm using MS SQL Server query. Few columns in the data have reserved key words in them for eg. [Opportunity Close Date]. Such columns can be addressed properly in SQL server by putting them in square brackets but PowerBI keeps throwing error, "Invalid Coumn name 'Opportunity Close Date'". I have tried writing such column names:
1) Using square brackets
2) In double quotes
3) In single quotes
4) Casting them as nvarchar()
5) Using table.column_name convention
6) Combination of 1 and 5
But still no luck 😞
Hi Nash_s,
Yes, when refer to field, you could use [#"Opportunity Close Date"] to see whether it work or not
In addition, you need to make sure there is no space at the end of column name, you could see my above image, there is a space at the end of [amount], so I need to use [#“amount ”].
By the way, did you refer to last steps's result? If so, you need to use last steps name instead of column name(you could see the #"Added custom" row)
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
daxCommunity Support
Hi Nash_s,
Yes, when refer to field, you could use [#"Opportunity Close Date"] to see whether it work or not
In addition, you need to make sure there is no space at the end of column name, you could see my above image, there is a space at the end of [amount], so I need to use [#“amount ”].
By the way, did you refer to last steps's result? If so, you need to use last steps name instead of column name(you could see the #"Added custom" row)
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I realized that there was space at the end of the field name that made PowerBI to not identify it properly. Thanks for the help. Appreciate it 🙂
Could someone help me? I am having the same problem but #"" didn't solve it for me.
I am using ODBC conector to connect to a server where I query the following:
Fonte = Odbc.Query("dsn=default-server", "select "from".taxid from clients")
In this case, using #"from".taxid or [#"from"].taxid keep returning the error "a token was expected ','".
How can I solve it?
