DB table name using dots as separators

[Anonymous]

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

[Greg_Deckler]

Maybe try the HTML escape sequence for "." .

?

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