Forum Discussion

MarkHoughton's avatar
MarkHoughton
Regular Visitor
9 years ago

Direct Query SQL table fails to import even though it previews correctly

Hi, I am new to PowerBI and just finding my way around. I have imported using direct query a number of tables and pull through financial information ok. However, I am attempting to build a department...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

MarkHoughton,

 

Can you get expected result by using this query in SQL Server Management Studio?

 

See similar threads below: 

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table... 

http://community.powerbi.com/t5/Integrations-with-Files-and/Expression-Error-The-key-did-not-match-a... 

https://community.powerbi.com/t5/Service/Key-Expression-Error-The-key-didn-t-match-any-rows-in-the-t...

 

Regards,

Charlie Liao

MarkHoughton's avatar
MarkHoughton
Regular Visitor
9 years ago

Hi, yes, when i enter the query in SQL managament studio the tables are merged as I expect, it displays the same results as the BI preview.