Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Attempting to pull data into Excel from a UDT. Receive "Expression.Error: The key didn't match any rows in the table." in Power Query.

Posted By Rodney Roberts over 1 year ago

Attempting to pull data into Excel from a UDT.

Raw data will pull, but,

when I try to edit Query, receive "Expression.Error: The key didn't match any rows in the table." in Power Query.

See screen shot :

Any Thoughts?

I have used "syzcon" running the Data Dictionary utility ("DD") to set table keys.

I need to pull specific data in a specific order into Excel.

Parents

0 connex over 1 year ago
When I add a Power Query from a Premium SQL Database it inserts the language of:

= Sql.Databases("MACHINE_NAME\SQLEXPRESS") = MAS_CNX{[Schema="dbo",Item="CI_UDT_CUSTOMERS"]}[Data]

for a pre-existing CI UDT for company code "CNX".
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rodney Roberts over 1 year ago in reply to connex

Many thanks. I could not replicate your setting, but it lead me to check my SQL server credentials which opened up functionality.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Rodney Roberts over 1 year ago in reply to connex

Many thanks. I could not replicate your setting, but it lead me to check my SQL server credentials which opened up functionality.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage 100

Attempting to pull data into Excel from a UDT. Receive "Expression.Error: The key didn't match any rows in the table." in Power Query.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING