Forum Discussion

wildande's avatar
wildande
Frequent Visitor
2 years ago

Set Visual to Specific Date and Time

Hi there,   I've been trying to get a solution for this to no avail. So I need to display visual from yesterday's date at 6:30 am to today's date at 6:30 am - So essentially 24-hour format but wit...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

Certainly. However :

 

- you will need to decide what "today's date"  and "6:30am"  means. Remember that the Power BI Service runs on UTC and your users may sit in many different timezones.

- this requires an import mode data source with (at least) daily refresh.

wildande's avatar
wildande
Frequent Visitor
2 years ago

Hi lbendlin 

Thanks so much for your time to reply back. I don't quite understand what you mean by import mode data source. Could you enlighten me on that? 

 

My Data Sources are coming from compilation of Excel and Text files, which I get with Get Folder directly into my Power BI.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Yes, those are examples of import mode data sources.  Data changes will not reflect in your report until you actively refresh the dataset (ad-hoc or via schedule).

     

    In contrast, with a Direct Query data source   changes in the data will show as soon as the report user interacts with the visuals. No refresh required.