Logical Model quirk in Tableau 2021.1
As we all love the logical model that helps avoid those LOD calculations, here’s a quirk I discovered in working with the latest and greatest 2021.1.
We have all gotten used to the drag and drop capability which speeds up development, however, it comes with a defect described below -
If you have a 2 Tables in your logical model, a Fact Table with a data source filter, and an Attributes table setup as Many-Many relationship, you will find that if you do not have all the attribute values in the Attributes table, then Tableau will automatically drop the mismatched records from the results in your Worksheets. Even though your Fact table contains valid records and transactions, the engine is not able to make the connection correctly and only fetches data for records that have matches.
Thanks to R&D @ Tableau, the only way around it at present, is to
import such Fact Table(s) as Custom SQL or
simply pre-filter the data at the root source
before importing it into Tableau. Problem Solved! Until next time…