Live,Report

[marcovenst]

Hi

I am connected to a SQL server via Direct query. I'm trying to filter months worth of data to the  latest running second. In other words, I want to report only the live process,  what is the best way to do that? It says that direct query doesn't allow me to filter all the way to the latest minute.

[v-yuezhe-msft]

@marcovenst,

Create streaming dataset which is introduced in the article below.

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-real-time-streaming/

Regards,
Lydia

[marcovenst]

Hi

I am connected toa SQL servervia Direct query. I'm trying to filter months worth of data to the  latest running second.In other words, I want to report only the live process,  what is the best way to do that? It says that direct query doesn't allow me to filter all the way to the latest minute.