Forum Discussion
Helper IWeb Content Dynamic URL
that could work you can create a new table to get no working days, compare it with the today date before its converted to tex\list, and when its a non working date them you can make it subtract the difference of today and last working day to get the last working date. somehting like that. I would recommend open a new topic ( if the main one of the date on url its done mark as soluction if it helped) for this las problem as its different from the main topic here, and its worth getting more perspective on it.
Resident Rockstaryou mean with your url it pulls 0 data and so returns a blank or invalid result? for this when you configure the auto refresh on power bi service you can specify it not to refresh on weekend (select a weekly refresh and specify the days it will refresh the data, them on weekend will remain the data of friday):
to try if the soluction works you can add a step to add a couple days on the date before the add new column step to try a future date on the query.
Helper IBecause there is no data being extracted it is not building the table. If I change the date to a day that has data the extract works fine and the table is built in the query.
- StefanoGrimaldi
ok, them yes, the work around this its to avoid the query to refresh on weeken by disable the sunday and saturday in the program refresh (setted as weekly).
- shippen70
StefanoGrimaldi The answer is not that simple because every weekday is not a working day. Fore instance 12/24 (thursday) and 12/25 (friday) were non-working days because of Christmas . I have a couple thoughts. One option might be to use my date table to find the last working day, if today is not a working day then use the last working day.