Forum Discussion
Records vanishes from table
Hello everyone,
Currently I have a report in which the following information:
Working Dates filter only for a single day selection
1. Table for changing the coming time - usually here are shown the people who chipped in wrongly in our system and needs to be fixed. This is set by specific rules for example if they start at 07:29 but they need to start at 07:30 and this needs to be inspected.
2. Table for mistakenly chipping in/out at the same timeslot.
3. And table for people who forgot to unchip.
For each of the specific tables I have filters but they are applied on each table separately.
Somehow, there is data in every table, and when I upload it to power BI is there, and after a minute, the data disappears from the table 1. Nothing is clicked, nothing happened, yet the table is empty.
Does someone knows why is this happening?
Thank you in advance.
Kind regards,
Stefani
Found and solved the problem.
Since I was creating the fixing time in power query, if you have only time column, it automatically generates tha dates from 01.01.1900 and when i was comparing in DAX whether tha timeslots from coming and coming changed matches, in the Power BI Desktop version everything was good the timeslots matched, but the moment it was uploaded in the Power BI web services, this was detected and it was detected as mismatched, therefore the rows were removed.
I think this bug should be fixed and both of the versions need to be synchronised when it comes to comparing times.
3 Replies
- Deku
Super User
So you import the data in to power bi.
You see the data is imported into power bi.
The data disappears from power bi and it not in the model at all?
Yes, both from the power bi and from the model.
Found and solved the problem.
Since I was creating the fixing time in power query, if you have only time column, it automatically generates tha dates from 01.01.1900 and when i was comparing in DAX whether tha timeslots from coming and coming changed matches, in the Power BI Desktop version everything was good the timeslots matched, but the moment it was uploaded in the Power BI web services, this was detected and it was detected as mismatched, therefore the rows were removed.
I think this bug should be fixed and both of the versions need to be synchronised when it comes to comparing times.
