Forum Discussion
Data Still Not Refreshing on Service
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?
The data in the fact table is just "Date" type.
The table below is from the desktop,
The table on the service is below. It still only includes up to 06/17.