Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
A weird issue has come up, and I'm not sure if this is an issue with how I created a field, or how the data is refreshing.
We have created an inventory forecast which uses data from multiple sources - inventory and orders from an internal data warehouse, planned production from an excel file. Because there are multiple sources, the data is imported, rather than continuously updated.
Not everything in inventory is currently available - some is undergoing testing and will be available at a later date. So I created a calculated column, a date field, which is set to today if the inventory is available, and to whatever its assumed testing release date is if it is not.
The visualization that shows the forecast is filtered for the next 13 months, starting from today. We have a reference date table - that date table and the inventory table are linked by [Inventory Available Date]
The problem is that the [Inventory Available Date] does not update in the published version. So if the data was refreshed yesterday, when I open the report today, for all records the field value is 2/10/19, even though today is 2/11/19. The visualization, however, knows the correct date, and so none of the current inventory is showing up in the table, since those values are yesterday.
With the desktop version - if I leave it open overnight and come in the next morning, the issue is the same - as soon as I click on something, change a filter, etc, the value for [Inventory Available Date] updates correctly. But for the web/published version, changing filters makes no difference.
Our current solution is to refresh the data daily, but this seems like an odd issue, and I'm wondering if there is something in how the column is coded, or if there is something in the published version that could fix this issue. Any thoughts are welcome!
Cheers!
Hi @smcdougal,
Here I suggest to configure schedule refresh of your report. And you can set the refresh time in the early morning everyday.
Regards,
Frank
Hi @smcdougal ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
Values in DAX columns are only calculated as part of the data import. They are not recalculated on the fly.
User | Count |
---|---|
65 | |
27 | |
25 | |
17 | |
11 |