Cognite PowerBI: Need Direct Query and Live Streaming Capability

@Anita Hæhre need response

Hi Ibrahim, thanks for highlighting this need.

We definitely want to support use cases where near real-time access to data is necessary. As of today, this is best served through our Grafana connector which (although not streaming) supports 10sec updates, and we see is the preferred choice across our customers for an easy-to-use no-code tool for SMEs. We are also updating it currently to support FDM alongside Cognite's traditional data types.

We are improving event-based support across the platform as well, starting with the MQTT data ingestion, which is in development now and planned for initial release this quarter (Q2 2023). We have plans to iteratively add more streaming support through workflow orchestration (i.e., running transformations on-event rather than schedule) as well this quarter. We do not currently have plans to support streaming in PowerBI; however, we do have support for Azure Stream Analytics on the roadmap for Q4 '23 - Q1 '24.

It would be interesting to hear more about the cases that you have in mind for Streaming support in PowerBI, and who in Celanese is developing on PowerBI today? 

We would also love to hear from the rest of the community on this!

cc; @Hunter Beck 

Best regards, Knut