You’re offline. This is a read only version of the page.
182
Hi lovely community,
Ive built an dataflow with an alternate key for integration. I already know how to use look up fields as part of my key and how to set up the integration key in admin portal.
My key is like this:
Quarterdate
Salesman (Contact Lookup)
Dealer (Account Lookup)
It works if theres content in all 3 fields. But if there's one record with "null" content in one of the lookup fields there's the following error message:
So all fields of alternate keys have to has content and can't be null?!
If its not an required field in table, how I can have an empty integration for it?
BR,
Sven
Hi @HSheild ,
have tested it with a Test table.
1. Test (alternate Key with 2 normal columns, Name + district )
Name Column (Primary Column of table) district (text column)
"Test1" "A-District"
"Test2" null
--> Data Integration works fine
2. Test (instead of district column as text, its now a lookup to table "district")
District has alternate key of "ID" (Text Column) and "Validtill" (Date Column) -> Works great in other LookUp columns without beeing alternate key
Name Column (Primary Column of table) district ID (part of lookup column) Valditill (part of lookup column)
"Test1" "54" "2021-01-06"
"Test2" null null
--> In this case there will be the error message "lookup value was not found"
Regarding to you question, in my query nothing is blank(), all empty columns are null.
BR,
Sven
Hi @KSven
When you are setting the lookup to ‘Null’ what is the input data? Is it blank or are you trying to import a value of Null? Are you able to share a screenshot of your Power Query transformation page?
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
