Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DB table name using dots as separators

Hello All,

I’m testing out a plugin that takes data from a poller and writes it into InfluxDB (time series db).  However, it appears Power Query doesn't accept the naming convention the poller creates, the poller uses “dots” as separators instead of underscores, for example  "a10.lsn.nat.tcp.ports.free".  To validate, I ran a test by duplicating the data and creating a new measurement named using underscores, "a10_lsn_nat_tcp_ports_free" which works.   Question, are there any escape codes/work arounds that can be used that allows Power Query to accept dots as separators?

 

Web query examples:

Doesn’t work:

http://xx.xx.xx.xx:8086/query?db=test&q=SELECT * FROM a10.lsn.nat.tcp.ports.free WHERE time > now() - 1d

Works:

http://xx.xx.xx.xx:8086/query?db=test&q=SELECT * FROM a10_lsn_nat_tcp_ports_free WHERE time > now() - 1d

 

Thank you in advance!

Mike

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    Maybe try the HTML escape sequence for "." .

    ?

    I don't know, that's a weird naming convention to have periods in your table name?