Forum Discussion
Data Still Not Refreshing on Service
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.
Hi Everyone,
I wanted to add one more piece of information....
Today I started a new report that is only my calendar table and my two invoice registers (which are appended in power query). When I created this new report, it initially published with the proper data, e.g. sales up to June 26, but when it refreshed on the service, it again went back to June 17. In this new report, I have only one Table visual, and no filters/slicers/etc, but still having the same issue.