Cross Join Help!

[LCook]

This is a direct query BI. I cannot transform the data or change the relationships. The current relationship is the employee ID.

Table 1

Activity ID	Level 1	Level 2	Hours	Date	Employee ID
1234	Dog	Walk	2.5	1/15/24	78945

Table 2

Date	Pay Type	Paycode	Hours	Employee ID
1/15/24	Regular	Hourly	2.5	78945

I cannot seem to find a solution that will merge the 2 tables into 1, while matching up the date and employee IDs. I want to be able to filter once by the date to see my data either way. Unfortunately, due to the data set being massive, the creator of the data set will not create a merged table for me. I have unsuccessfully tried cross join in a new table. Thank you in advance for your help!! 

[v-binbinyu-msft]

Hi @LCook ,

Please change the storage mode from Direct Query to Import.

For Direct Query mode, there are many limitations.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[LCook]

Hello,

I don't have the option to switch from Direct Query to Import at this time. 

[v-binbinyu-msft]

Hi @LCook ,

Please refer this link: Solved: How to change direct query to import query - Page 2 - Microsoft Fabric Community,

hope it is helpful for you.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[LCook]

Hello,

The option to change is not available. It does show "Storage Mode: DirectQuery" but it cannot be changed.