Error - OR not support in JOIN currently

[amitjain1987]

Hi Team,

I am facing one issue while creating a simple join in power BI. Would be helpful if you have any inputs.

Below are the steps I am following –

1. Connected to Hive using Interactive query.
2. Fetched 1 fact table and 4 dimension tables.
3. In Edit query, joined fact table and 1 dimension table – Using merge, left outer join.
4. Expanded dimension table and selected only 1 field.
5. Applied and closed.
6. Then get below error –
7. 

[v-piga-msft]

Hi  @amitjain1987,

Could you please share sample data of your fact tables and dimensions for us to troubleshoot? Also please describe which fields you use in each table to create relationship.

Best Regards,

Cherry

[amitjain1987]

I am using 2 tables here -

1. Fact table - Fact_test_v2, this has only 2 records with data for only company code 1071. For joining, I am using cc_companycode

2. Dimension table - t_comp_code_1071, this has only 1 record for company code 1071. For joining, using cc_company_code