Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am experiencing a filtering issue between table visuals in DirectQuery mode.
I sourced the dataset from SQL server via DirectQuery mode. As shown in screenshot 1 and 2, table visuals do not filter correctly when the Timestamp field (data type: Date/Time) is included in the table. This is only an issue in DirectQuery mode. As you can see in screenshot 3, when I switch to import, the filters work fine even when the Timestamp field is included in the table.
Solved! Go to Solution.
Hi,
Eventually, we spotted that the issue happened because Power BI does not like milliseconds.
When I was querying the Timestamp field without milliseconds, the filtering was working even in DirectQuery mode.
Hi,
Eventually, we spotted that the issue happened because Power BI does not like milliseconds.
When I was querying the Timestamp field without milliseconds, the filtering was working even in DirectQuery mode.
@LexiQiang ,
Glad to hear the issue is solved, you can accept your reply as solution to close this issue.
Regards,
Lydia
Thankyou for posting the problem, at least I can say I'm in the same boaat,
so dont display datetime fields in direct mode, you wont be able to filter data.
I think that Microsoft should solve this annoying bug and cannot consider this a solution....
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |