Forum Discussion

fabricator1's avatar
fabricator1
Icon for Advocate II rankAdvocate II
2 years ago
Solved

Do model relationships impact SQL queries on SQL Analytics Endpoint / Data Warehouse?

Hi! I read this thread Solved: Re: Building relationship in Fabric Datawarehouse ... - Microsoft Fabric Community and this documentation article Define relationships in data models for data wareho...
data engineering
data warehouse
power bi
  • HimanshuS-msft's avatar
    HimanshuS-msft
    2 years ago

    Hello fabricator1 
    Thanks for using the Fabric community.

    Your undersanding is correct as PK is not enforced the system will not stop you from entering the duplicate again . While you load you will have to make sure that duplicates are NOT inserted into the table , or may be you periodically clean up duplicate by checking on the table .


    Thanks
    HImanshu

HimanshuS-msft's avatar
HimanshuS-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Hello fabricator1 
Thanks for using the Fabric community.

Your undersanding is correct as PK is not enforced the system will not stop you from entering the duplicate again . While you load you will have to make sure that duplicates are NOT inserted into the table , or may be you periodically clean up duplicate by checking on the table .


Thanks
HImanshu