Forum Discussion
Data Still Not Refreshing on Service
Do you have a date dimension table in your model? If yes, what's the most recent day in it?
Hello again,
In my desktop version, I see the below,
and on the service I see the below.
I circled the last day that shows up in both, but it is off slightly. I checked the invoice register and I do not have an invoice that matches the discrepancy amount.
Looks like a matrix, not a table. Can you create a table where both the dimension and fact date columns are shown?
Good Day,
I have created a table in my desktop version and published it to the server. I then extracted the data from both.
What I see for the desktop on the last day the servic worked (June 17) is below, (note I hid customer information columns)
And for the service I have the below (customer details hidden again),
Two issues come to me when I look at this. The first is that for the data in the desktop, time is included, although I am not sure if that could create the issue. I also see an order that it is in the service but not the desktop (order 238931). I believe this should not be there....
Thoughts?
It's hard to help if you're not going to provide the requested info:
- Is the date in the fact table of date or datetime type?
- Can you produce the requested table in Power BI, not Excel?