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
MarkHoughton's avatar
MarkHoughton
Regular Visitor
9 years ago

Hi,

 

I know it's not importing, but I don't know what other term to use and to my mind because I am merging 2 different tables then I feel like I am 'importing'. Anyway....

 

Here is the script

 

select Dept2.[MEM_DESC] as 'Parent Dept',Dept2.MEM_ID as 'Parent Id',Dept1.MEM_ID as 'Dept Id', Dept1.[MEM_DESC] as 'Child Dept' from [CLIVE].[CLIVE].[CUST1] Dept1 inner join [CLIVE].[CLIVE].[CUST1_TREE]  DeptTree on Dept1.MEM_ID=DeptTree.MEM_ID inner join [CLIVE].[CLIVE].[CUST1] Dept2 on Dept2.MEM_ID=DeptTree.MEM_PID

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.