cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
arefossa Advocate I
Advocate I

Filter updated based on time / count number of times refreshed...

Hi!

I had an idea for a report that could be cool to try out. Problem is I suspect some of the functionality for my solution would be impossible in Power BI as of now, but maybe someone has a solution to such a report.

 

I have created a report collecting a set of news headlines, abstracs and images. I added a slicer where the user could select a headline and basically get the case baseline and a button to go to the news outlet.

 

What I would like to do is update the current selected headline every few minutes. So I was wonder if I could do this by using a live time measure like NOW(), or would this have to be done through data refresh? If it had to be updated by a datarefresh, is there a way to implement a variable where we count number of refreshes? Or would it be better to create a time period for each headline one could join with a time dimension to check which headline would be shown at this current time?

 

Has anyone tried something like this? I would love to hear about it if you have!

 

Best regards

arefossa

 

image.png

1 REPLY 1
Community Support
Community Support

Re: Filter updated based on time / count number of times refreshed...

Hi @arefossa 

If you connect to data source and import data into Power BI,

Then you need to refresh the dataset so that the newest data updates and shows on report.

When publishing reports to Power BI Service , manually/configure schedule refresh if need,

you can find "refresh history" of a dataset under "the dataset->Setting.

Here you can find how many times the dataset refreshed.

 

Best Regards
Maggie

 

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors