Forum Discussion
NOW() Function Not Updating on Refresh (Web Service)
Hi V-lianl-msft
I believe I found the issue.
The table that contained the NOW() function was NOT set to "Include in report refresh".
This table has been set this way for over a year and previously the column that used the NOW() function would still update even though the underlying data was not being refreshed. The underlying data did not need refreshing so I set it this way purposely.
Something changed recently that is now preventing columns that use the NOW() function from being updated if the table is NOT set to "Include in report refresh".
The desktop console still updates columns that use the NOW() function even though the table is NOT set to "Include in report refresh". When I publish from the console to the website, the NOW() column is accurate. However, once I try to refresh via the web service the column that uses NOW() no longer updates.
I've used this data model for over a year and never ran into this problem. I've made no changes on my end to it. Something has definitely changed on the web service end with regards to how the NOW() and likely other time/date functions are handled when they are used to populate columns on a table where the underlying data is not set to "Include in report refresh". The NOW() function when used to populate a column was previously independent of whether or not the underlying table was being updated, now it seems dependent on it.
Hi Anonymous ,
Unfortunately, I was able to use now() and refresh normally.
Check whether the dataset is refreshed successfully
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi V-lianl-msft
I think I narrow it down a bit.
The issue of the NOW() function not updating (via web service refresh) when used in a column only occurs when the original source of the table is Excel.
When I use the function in a column of a table whose original source is our internal database or a manually created PBI table, the column updates as expected when using the web service refresh.
Hi V-lianl-msft
I believe I found the issue.
The table that contained the NOW() function was NOT set to "Include in report refresh".
This table has been set this way for over a year and previously the column that used the NOW() function would still update even though the underlying data was not being refreshed. The underlying data did not need refreshing so I set it this way purposely.
Something changed recently that is now preventing columns that use the NOW() function from being updated if the table is NOT set to "Include in report refresh".
The desktop console still updates columns that use the NOW() function even though the table is NOT set to "Include in report refresh". When I publish from the console to the website, the NOW() column is accurate. However, once I try to refresh via the web service the column that uses NOW() no longer updates.
I've used this data model for over a year and never ran into this problem. I've made no changes on my end to it. Something has definitely changed on the web service end with regards to how the NOW() and likely other time/date functions are handled when they are used to populate columns on a table where the underlying data is not set to "Include in report refresh". The NOW() function when used to populate a column was previously independent of whether or not the underlying table was being updated, now it seems dependent on it.
Hi Anonymous ,
It's glad that you have solved your problem.Thanks for your update.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.