PBI Report Builder doesn't recognize relationships created in PBI Desktop

[sultrax]

Hey guys!

I've started learning about PBI Report Builder but I got stuck on something basic: relationships between tables.

Just as a test, I created two fact tables in PBI Desktop, one for sales and one for returns. Both contain columns for product and date.

So I created two dynamic columns, one for product and one for date, and related them to the two fact tables.

 

Of course, I could bring the returns' column to the sales' table and everything would be solved, but my objective here was exactly to test the relationships.

Seeing that they worked perfectly on my dashboard, I published my .pbix and imported the semantic model as a PBI RB dataset and guess what... it didn't recognize the relationships created.

In the Microsoft Learn video course, instructors are dealing with an older version of PBI RB in which there is a relationships panel, which is no longer part of the new version.

So, to make a long story short: how, in this cruel world, do I import relationships between tables created in PBI Desktop into PBI RB?

Thank u for the angel who will enlighten my mind!!

[EcurieArgyll]

This is seriously disappointing. I just lost the guts of a day to this. I'm going to have to build one big flat table for the report I need to do because I cannot get Report Builder to recognise the relationships in a semantic model. So that will cost more CU, more space, more time. Pretty gutted.

[GilbertQ]

Hi @sultrax 

It looks like the relationships are not working?

[GilbertQ]

Hi @sultrax 

When you are using the report builder and accessing the semantic model, the relationship should automatically be consumed via the semantic model. If you could please try that out and let us know.

[Doug_B]

I am encurring the same issue. I am able to pull in the PBI semantic models that are published to service but the query designer does not recognize existing relationships between the tables already built. I did a basic pull of my Calendar table and a Fact table and tried using the Calendar table as a filter with no success.

[sultrax]

Hi, @GilbertQ , thanks for answering. I've been trying, without success. I am uploading two datasets for you to see. In the first one, i am running the query only with the columns of the sales table.

In the second one, i substituted the product and date columns for the ones created in the dTables.

Shouldn't they be running the same query? Why are the second one showing me these repetition of values?