Forum Discussion

BracePBI's avatar
BracePBI
Frequent Visitor
5 years ago

Dataset refresh based on date field

Hi All,

 

I have a Transaction date field from dataset. Transactions happen only from Monday to Friday

Every day Data Refresh should happen based on  Latest Transaction date-1


Dataset should refresh everyday.

Please let me know the process to setup data set refresh based on latest Transaction date-1

 

Regards,
PBI Brace

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi BracePBI ，

    Currently Power BI only supports set the frequency of data refresh as on daily basis or on weekly basis, and then select the time slot (every 30 minutes). If the dataset is on shared capacity, the daily refreshes times is eight. If the dataset is on premium capacity,  the times of daily refreshes can be up to 48. It can't get the specific date from the dataset and customize the refresh... You can configure a schedule refresh base on daily basis, and the refresh time is set after the end of the day’s transaction.

    How To Configure Schedule Refresh In Power BI Reports?

    Best Regards

  • BracePBI's avatar
    BracePBI
    Frequent Visitor
    5 years ago

    Thank you for the update.

    I have primary table  A with all the data and date field (Transaction_date).
    I have another Table B Where i have the date field(Latest_Date) .

     

    My expectation is to refresh dataset based on  passing the value of (Latest_date) to  (Transaction_Date)

    Please let me know the process to achieve this senario to refresh dataset based on Latest_date value

    Regards,





    PBI