Reply
marcovenst
New Member

Live,Report

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.

2 REPLIES 2
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
marcovenst
New Member

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.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric Community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)