Streaming Dataset - Measures

[itchyeyeballs]

Hi All,

We have managed to set up a streaming dataset that is driven via a Powershell script which pulls data from our SQLServer DB. Everything is working well apart from some really stange behaviour when trying to create measures, does anyone know if there are any known limitations when working in this way?

One measure we have tried is:

CALCULATE (
    [Total],
    FILTER (
        ALL ( RealTimeData[timestamp] ),
       RealTimeData[timestamp] = MAX ( ( RealTimeData[timestamp] ) )
    )
)

RealTimeData[timestamp] is a datetime field

This has worked in other reports but not with the streaming datset. We have also noticed that trying to use a top N filter also behaves strangely.

I have searched online but the documentation (that I have found) is not very clear 

Any thoughts appreciated

[JasonWelch]

Found this when having what I think is same issue:  https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Simple-cumulative-sum-issue-with-liv...

Can you link your "feature request" aka bugfix (if you made one)?

[v-frfei-msft · Accepted solution]

Hi @itchyeyeballs ,

Based on my test, it is not supported yet currently. You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

[Anonymous]

@v-frfei-msft , I'm just building a solution where this feature is a must. Added new 'idea post' about this feature/bug.

Regardless, do you have any information whether it will be resolved?

Thanks,

Rafal

[annetoal]

Is there any news on this? I'm facing a related issue. Anne

[itchyeyeballs]

Thank you,

Is there any documentation about this available? It seems more like a bug than a missing feature especially as I got no warnings or errors, just erroneous outputs.