Forum Discussion
Impactful Individualdetecting when last refresh was from within pbix
Hi db042190 ,
Yes if you are looking at the expression today it will return the current date, however since you are making a refresh of your semantic model (assuming import mode) this will be picking up the date of that refresh so if you do it now it will get July 8th however if you do not refresh your semantic model that value would be "frozen".
Impactful Individuali gave this some thought yesterday. In our case i think both mfelix and amy are right and we need to do a little of both. We have only pro and without researching how much that impacts the following, here's the story. On sundays we run our etl much later than the rest of the week. due to pbi limitations in refresh flexibility, we finally got around to a second refresh schedule to accomodate the late sunday etl start/finish. Unfortuanately, even with mfelix's more sophisticated "extra table" in the SM, pbi cant determine the as of date purely by what the extra table says. The last etl run date would always have to be an additional factor in that decision. in some ways, this argument can be extended to weekdays if/when our etl is delayed. and there is one use case there that i wont get into here. but unless im not thinking this thru, our pbi needs to consider both dates/times, refresh and last etl run to make the right decision. which also means the upper limit of our planned date range filter needs to be a little smarter than orignally thought.
