Sorting is not available on visuals built on a streaming dataset

[RealSlimShady]

I need to sort my data by the Event time in my table, but the sort option is missing on the visuals when using a streaming dataset.

Infact most of the useful functionality of powerbi seems to be greyed out and unavailable. It won't even let me add a local model. 

I just get this error.

[Anonymous]

Hi @RealSlimShady ,

First of all, many thanks to  for your very quick and effective replies.

Based on the knowledge, the streaming semantic model has no underlying database, so it is impossible to use report functionality such as filtering, and other report functions.

You can view the following documents to learn more about streaming dataset.

Real-time streaming in Power BI - Power BI | Microsoft Learn

Load data in a Power BI streaming dataset and build a dataflows monitoring report with Power BI - Po...

Writing calculations on a real-time streaming Power BI dataset using DAX measures - RADACAD

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

A streaming dataset has the same limitations as an OLAP cube. no calculated columns, no measures, none of that. But sorting is possible.  What are you trying to sort by?