Relationship with different published datasets

[ShortyAO]

Hello,

I am working on creating a dashboard that is connected to different published datasets.  When I try to link the dates to each other or a calender tables I get the following error message.  Any thoughts on how I can get a date relationship to work?  Or is this not a possibility?  First time I am trying to build a dashboard with already created datasets.  Any guidance would be much appreciated.

Anya

[DataInsights]

@ShortyAO,

You can create a master date table in the pbix, and create a relationship between the master date table and the date table in each published dataset. Use the master date table in a slicer to filter the other date tables.

[ShortyAO]

I do have a master calender table.  I also have master category table.  I am able to create relationships to the category table.  However, when I try to create a relationship to the calender master table I get the error below.  Is more then one master table supported when using that Data Query Analysis Services? 

[DataInsights]

@ShortyAO,

See the article below for limitations related to Analysis Services:

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models