3rd party integration
3 Topics
Date Field not aligning for WpA & non-WpA data sets
Hi, I have the following issue -- when two datasets, one a query from Workplace Analytics (Viva Insights) and one separate one -- are joined in PBI by a key other than a date, the date field cannot be used as a common axis (aka, it does not align). The only workaround I found was to create a separate dates table and use it to join the two datasets, however, the drawback of this is that this being an active connection, it prevents me from making connections through other keys. I checked all date formats etc., and those align for both data sets (rendering it possible to use date as a joiner key). I think that is not the case when two WpA datasets are joined. Any ideas on how to prevent this? VI_MigrationSolved1.8KViews1like3Comments