Comments (6)
soundstripe
commented on August 11, 2024
#10 should fix this. Needs real-world data testing.
from odata-influxdb.
srp-synengco
commented on August 11, 2024
Yeah, when I get a chance I'll put some data into our test environment with spaces and see how I go to test that out
from odata-influxdb.
mkarlesky
commented on August 11, 2024
Tried out the latest with our testing instance of Influx. Definitely see some progress in that our ‘Air Temperature’ measurement is now showing up in the base feed where previously it was not. However, it seems this has flushed out a new issue. Incidentally, the connection from Power BI is still failing with the same error as previously.
Here's the server log upon starting up and connecting to Influx:
⚡ python server.py
INFO:odata-influxdb:Generating OData metadata xml file from InfluxDB metadata
WARNING:root:Bad attribute value for ('~', u'Name'): farmlab__Air Temperature
ERROR:root:EntitySet farmlab__Air__sp__Temperature has undeclared type: InfluxDBSchema.farmlab__Air__sp__Temperature
INFO:odata-influxdb:Starting HTTP server on port 9999...
And here's a snippet of the metadata. Note that ‘pH’ has an EntityType but ‘Air__sp__Temperature’ does not. I'm supposing the error in the server console log is directly related to this omission as is Power BI's complaint.
<EntityType Abstract="false" Name="farmlab__pH">
<Key>
<PropertyRef Name="time"/>
</Key>
<Property Name="time" Nullable="false" Type="Edm.DateTime"/>
<Property Name="Location" Nullable="true" Type="Edm.String"/>
<Property Name="Units" Nullable="true" Type="Edm.String"/>
<Property Name="Test" Nullable="true" Type="Edm.String"/>
<Property Name="Value" Nullable="true" Type="Edm.Double"/>
<Property Name="Sensor" Nullable="true" Type="Edm.String"/>
</EntityType>
<EntityContainer m:IsDefaultEntityContainer="true" Name="InfluxDB">
<EntitySet EntityType="InfluxDBSchema.internal__cq" Name="internal__cq"/>
<EntitySet EntityType="InfluxDBSchema.internal__database" Name="internal__database"/>
<EntitySet EntityType="InfluxDBSchema.internal__httpd" Name="internal__httpd"/>
<EntitySet EntityType="InfluxDBSchema.internal__queryExecutor" Name="internal__queryExecutor"/>
<EntitySet EntityType="InfluxDBSchema.internal__runtime" Name="internal__runtime"/>
<EntitySet EntityType="InfluxDBSchema.internal__shard" Name="internal__shard"/>
<EntitySet EntityType="InfluxDBSchema.internal__subscriber" Name="internal__subscriber"/>
<EntitySet EntityType="InfluxDBSchema.internal__tsm1_cache" Name="internal__tsm1_cache"/>
<EntitySet EntityType="InfluxDBSchema.internal__tsm1_engine" Name="internal__tsm1_engine"/>
<EntitySet EntityType="InfluxDBSchema.internal__tsm1_filestore" Name="internal__tsm1_filestore"/>
<EntitySet EntityType="InfluxDBSchema.internal__tsm1_wal" Name="internal__tsm1_wal"/>
<EntitySet EntityType="InfluxDBSchema.internal__write" Name="internal__write"/>
<EntitySet EntityType="InfluxDBSchema.farmlab__Air__sp__Temperature" Name="farmlab__Air__sp__Temperature"/>
<EntitySet EntityType="InfluxDBSchema.farmlab__pH" Name="farmlab__pH"/>
</EntityContainer>
from odata-influxdb.
srp-synengco
commented on August 11, 2024
#11 works for me but I'll let you have a go first @mkarlesky before I close this one off
from odata-influxdb.
mkarlesky
commented on August 11, 2024
No more errors in the console log. Base feed and metadata both look good in a browser.
Oddly, Power BI reports that it's unable to connect to the server (and no traceback in the odata-influxdb console log). A browser on the same machine is able to connect fine and generates a traceback.
I'd say issue #9 is resolved, and we need to do some troubleshooting in Power BI.
from odata-influxdb.
srp-synengco
commented on August 11, 2024
Thanks mate, will close this one
But feel free to post what you find it out to be here anyway, sounds like it could be useful to know for us / others (& of course, if it's a bug, don't hesitate to raise an issue 😄)
from odata-influxdb.
Related Issues (15)
- Problem loading data with fractional time stamps HOT 2
- Embedded service URL different from server URL HOT 4
- How to form queries with time filters? HOT 4
- Not seeing Grouping statements in Influx queries HOT 5
- All fields across all measurements advertised for each measurement? HOT 2
- Methods renamed in pyslet.odata2.client and influxdb.client HOT 1
- Werkzeug dependency not mentioned HOT 1
- KeyError: u'boolean' HOT 3
- Any Python3 supports for this project in the future? HOT 4
- Handle spaces in key/field names
- Reflect nested structure of influx database -> measurement HOT 2
- Implement authentication HOT 1
- Add more tests HOT 1
- We're trying to integrate InfluxDB with Power BI. Do the errors we're seeing mean OData v3 / v4 is required? HOT 10
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from odata-influxdb.