Can't create relationships in Fabric warehouse

[weetom]

Hi,

I've created a Warehouse in Fabric with tables and views, when I'm in model stage there are no relationships and as soon as I try to create a relationship it shows:

It doesn't matter which table I drag the relationships between, nothing works, anybody knows how? 

[weetom]

I would like to add for future users that develop semantic models in fabric that the worked the best for my situation is that you create your own semantic model in Fabric, open the power bi desktop and connect to the warehouse, choose the tables or views that you want in IMPORT mode and the upload the semantic model with measures and relationships.

It almost feels like you connect to a analtyics cube then, because conenct directly from Fabric Warehouse in a Power BI report with direct query is more laggy and the user experience isn't the best for instance the date hierachy isn't automatic in Direct Query, so big recomend is to create your own semantic model from a onelake/warehouse and then import on the tables you want. 

[v-jialongy-msft]

Hi @weetom 

Is your problem solved, and if so, please mark the corresponding reply as a solution, which will help users with the same problem to better solve their problem.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jonvoge · Accepted solution]

Hi weetom.

Instead of working with the default semantic model, can you try to create a new semantic model on top of your warehousem from the Model tab in the Warehouse?

Hope it helps.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data