Hi all I have just come across what I think is a bug in the relationships view of PBI Desktop. When I drag the primary key from one table to the key field of another table to establish a rel...
Creating relationship- Feb 2025 version of PBI I have a more basic issue, but found your post and thinking somehow its connected. I am facing issues creating relationships between table columns and displaying the result. Need to add that I am using a filter in the transform window to filter out a subset of data from Table 1 say on Col A of Table 1 the filter is applied on and only want the relevant information from Table 2 for the filtered values of Table 1 to be displayed. Table 1 and Table 2 are related on the filtered Col A of Table 1 to the corresponding column of table 2. The result is displaying blanks, and a workaround would be to filter out the blanks, but the relationship functionality is broken in my opinion. I did not have to do this filtering out in the past if the filter(transform window) and the relationship was defined properly.