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 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
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.