Forum Discussion
conditional relationship
Hi, I am importing tables from SQL Server into Power Bi. Two tables, named TB and AP, have a 1-to-many relationship with a condition, ie: TB.VLAS=AP.TPGE AND CDA = '025' AND NMF = 'AP' and NMC = '...
General advice: Most tables/relationships in SQL Server are designed as a balance between input/update/selection. They are supposed to be normalised (supposed to be). Powerbi is a reporting system which is designed for reading of data. Use a star schema to optimise this and you transform the data in Power Query.
--
So the answer to your question may go away because you've changed the design. It is,generally, a mistake to import the tables from SQL Server as they are and try to recreate the relationships. In powerbi, you can't have multiple key relationships anyway.