Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
How to select table column when column name contains dot . I tried to use 'name.1' but still getting error. How to resolve it?
Solved! Go to Solution.
Hi @Analitika
I could reproduce the issue like yours. My column name in SQL is [Name.1], Power BI seems that couldn't identify the column name with dot.
I think you could try to rename the column name in SQL. If you replace "." by "_",it works well.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Analitika
You can use within square brackets without quotes as follows
Tablename[ name.1]
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Still not helped, I am getting similar error like: DataSource.Error: ODBC: ERROR [42601] ERROR: syntax error at or near "["; when I have tried to use a bracket - [name.1] for example.
Hi @Analitika
I could reproduce the issue like yours. My column name in SQL is [Name.1], Power BI seems that couldn't identify the column name with dot.
I think you could try to rename the column name in SQL. If you replace "." by "_",it works well.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
23 | |
3 | |
2 | |
2 | |
2 |