cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mulder2542
Frequent Visitor

Relationship with calculated table doesn't appear when using dataset as data source

We have a dataset using a star schema, which is used as a data source for several reports. This works fine, however one issue we have is that a couple of dimension tables have thousands of entries, so the filters on those are rather inconvenient to use.

 

So I looked into a couple of options to reduce the fields by only keeping the ones whose keys are present in the fact table. One option that seemed feasible, is to create a filtered copy of the dimension table (via CALCULATETABLE(Dimension, Fact)) and then create a 1-1 relationship between both, using the filtered copy to filter. This works when tested in a report within the dataset file itself.

 

When importing the published dataset for use in another report however, the relationship between the dimension table and the filtered calculated table does not show up and the filter therefore won't work. What could be the reason of this?

 

2 REPLIES 2
HotChilli
Super User
Super User

Powerbi didn't auto-create the relationship?  Try to create it manually and see if there are any feedback messages.

The relationship is already in the model, but it's gone when you connect a different report/PBIX file to it. It doesn't seem possible to make any manual changes to the model of reports that use another dataset to get data, so it can't be reinstated there.

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.