Assume in your data model you have Many-to-One relationship between your 'FactTbl' and 'DimTbl' on the column 'CustomerKey' and the the connection is in DirectQuery mode.
Now assume that bad data is entered in your 'DimTbl' and it has caused that you have a duplicate value in the column 'CustomerKey' of your 'DimTbl'.
If you refresh your Power BI, it gets refreshed successfully without any errors.
Now what happens? If you have created visualizations before, you might see some data in your visuals that is too weird which are caused by Many-to-Many Relationship behavior. You go and check your data model to find out the reason and it shows you that the relationship is Many-to-One and it is too frustrating as you cannot find the reason of what you see !
But the same case in Import mode works fine and once you hit the Refresh button in Power BI, it gives you the error:
"Column CustomerKey contains a duplicate value and this is not allowed for columns on the one side of a many-to-one relationship or for the columns that are used as the primary key of a table".
The same error is expected in DirectQuery mode as well and it needs to be fixed.
Regards,
Loran
on:
Get rid of Microsoft sidebar in Power BI new works...
on:
Improve Bookmark Pane Usability: Persistent Menus,...
on:
Case Sensitivity ragrdless of the connection type ...
frithjof_v
on:
Lakehouse SQL Analytics Endpoint snapshots
on:
Power Query - Feature addition - To keep duplicat...