Select column with "." in the name

[Anonymous]

Hi all,

I have a problem as I want to collect only a few columns from a table. But the column name in the database have a "." in it, which gives an error: extraneous input '.0' for example. In the column alrmbitsfeeddrive.0.

Here my query, how can I make it so power bi sees it as a column name. 

= Odbc.Query("dsn=" & ConnectionName & "", "
SELECT timestamp,

runningshours,

alrmbitsfeeddrive.0, 
alrmbitsfeeddrive.1,
alrmbitsfeeddrive.3,
FROM " & TableName & "
WHERE serial_number = XXXX
ORDER BY timestamp ASC
")

Hope you can help me

[JosefPrakljacic]

Depending on the Database you are selecting from if its a SQL Server you need write your columnnames within brackets and if it's a oracle database you need to select the columns within ". 

Was the answer helpful? Please share some Kudos 

[Gordonlilj]

Hi,

Have you tried using brackets with the columns like this [alrmbitsfeeddrive.0]

[Anonymous]

Yes tried that aswell.. Gives same error

[JosefPrakljacic]

Which underlying DB Vendor do you have? Postgres, Oracle, Microsoft, MySQL...

[Anonymous]

Hi,

Thanks for helping!

Sorry, But where can you find that? 

Could it be azure sql databasE?

This is the Power bi version: Versie: 2.68.5432.841 64-bit (april 2019)

[JosefPrakljacic]

I think we have a misunderstanding here. You are querying a database via ODBC. So you have to know what kind of vendoris behind this database. I can't answer that for you.

But from the beginning your query has to look like this to work on a SQL Server:

= Odbc.Query("dsn=" & ConnectionName & "", "
SELECT timestamp,

runningshours,

[alrmbitsfeeddrive.0], 
[alrmbitsfeeddrive.1],
[alrmbitsfeeddrive.3],
FROM [" & TableName & "]
WHERE serial_number = XXXX
ORDER BY timestamp ASC
")

BR,

Josef