Report Builder - Relationships
As a simple test for the creation of a dataset in PBI Report Builder, I imported two tables to PBI Desktop: one with product sales and another with product devolutions. After that, i created two dynamic tables: one for product name and another for date. As the two main tables had columns for product name and date, i related them with the dynamic tables, everything worked fine and I published it all into my workspace. So, in PBI Report Builder, I imported the data source from my workspace and started creating a dataset with the table wizard. I used the dProduct Name table as a parameter, the dDate table as the only line and the Sales and Devolutions Quantities as the values to be shown. But the PBI Report Builder doesn't understand the relationship between the original and dynamic tables, even if they are consolidated on PBI Desktop. Worse than that: both the written course and the video course on Microsoft Learn show a relationship pane inside the Query Designer of the Dataset and i can't find anything like that on my version (15.7.1807.730). So, how can i create a simple relationship between columns of different tables on PBI Report Builder? I have seen some stuff about the subject here in the forum but I still can't apply any of that on the last version of PBI Report Builder. Thank you so much. PS: It is also difficult to find an specific topic for PBI Report Builder here.