Relationships not working in Power BI Report Builder

[dmontgom2000]

I have created a simple semantic model and published it to the service.  There are 3 fact tables and one simpe date table.  The relationships work perfectly within power bi desktop.  However when connecting to the Semantic Model within Report Builder it seems that the relationships no longer work.  Is this a known bug?  It seems to be.

[dmontgom2000 · Accepted solution]

It was a simple star schema.  I ended up abandoning the idea and went a different route after reading more about Power BI Report Builder's behavior related to relationships built in semantic models  

[v-sshirivolu]

Hi @dmontgom2000 ,

Thank you for the update. Could you please share the solution you tried?

[v-sshirivolu]

Hi @dmontgom2000 ,
If the issue has been resolved, please mark the appropriate response as the solution so other community members can find it more easily.

[v-sshirivolu]

Hi @dmontgom2000 ,

Could you share a screenshot of your model showing how the date table connects to the three fact tables so that It’ll help to see what kind of relationships you’ve set up. Also, if you’re using a DAX query in Report Builder, please share that too. That way, we can check whether the relationships are being recognized correctly or if they need to be defined manually in the query.

[v-sshirivolu]

Hi @dmontgom2000 ,

Were you able to check the model screenshot and DAX query? Sharing them will help us understand the relationships and provide accurate guidance.

[Pragati11]

Hi @dmontgom2000 

Can you plezase share a screenshot of the semantic model? It will be nice to see what type of relationships you have created with One date table and 3 fact tables.