Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
AnilKumar
Helper II
Helper II

Regarding Direct query

Hi,

 

I want to know whether the direct query gives the current data in visuals with out any refreshing. Our data will updated in database for every minute. Is it possible to use direct query for this requirement? As we want to see the live data in our visuals without manual refresh or schedule refresh in powerbi service.

 

Thanks & Regards,
Anil.

 

 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

@AnilKumar ,

DirectQuery can't achieve the above requirement as you describe. It requires schedule refresh or manual refresh in Power BI Service.

You can consider to push data from your database to Power BI streaming dataset, and create a streaming dashboard, which will display live data in visuals without manual/schedule refresh.

There are some blogs for your reference.
https://powerbi.microsoft.com/en-us/blog/push-rows-to-a-power-bi-streaming-dataset-without-writing-a...

https://blog.crossjoin.co.uk/2016/11/08/pushing-data-from-excel-to-power-bi-using-streaming-datasets...

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.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

yes u need to refresh the report page only...and u dont have to refresh dataset

 

 

v-yuezhe-msft
Employee
Employee

@AnilKumar ,

DirectQuery can't achieve the above requirement as you describe. It requires schedule refresh or manual refresh in Power BI Service.

You can consider to push data from your database to Power BI streaming dataset, and create a streaming dashboard, which will display live data in visuals without manual/schedule refresh.

There are some blogs for your reference.
https://powerbi.microsoft.com/en-us/blog/push-rows-to-a-power-bi-streaming-dataset-without-writing-a...

https://blog.crossjoin.co.uk/2016/11/08/pushing-data-from-excel-to-power-bi-using-streaming-datasets...

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.

Hi,

 

I have another question to get clarify .  My data is stored in SQL database. I would like to know when ever the data is inserted ,updated in database , is there any possibility to get reflected in Power bi with out manual or schedule refresh ?

 

Please share the detailed links as I can't find in any power bi sites clearly . As mostly discussing about the schedule refresh .

 

Can we do it using API's  ???

 

Regards,

Anil

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors