Forum Discussion

Heinrich's avatar
Heinrich
Icon for Post Partisan rankPost Partisan
2 years ago

Copy all data from direct query table

Hello I have access to CQD (Microsoft Teams Table - Direct Query). I would like to copy static data to a local table. Either some columns or all the data. Do you have a Script or way to accomplish...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
saudansari's avatar
saudansari
Icon for Helper II rankHelper II
2 years ago

I am unsure if this will work but you can create a calculated table in DAX

LocalTable =
SUMMARIZE(
'TeamsTable',
'TeamsTable'[Column1],
'TeamsTable'[Column2],
-- Add other columns as needed
)

if this works please accept it as solution

Heinrich's avatar
Heinrich
Icon for Post Partisan rankPost Partisan
2 years ago

Hello Saudansari
Hope you are doing well
Thank you very much for your support
1. Dataflow has to be licensed right. Then this is not enabled

2. Your solution

LocalTable =
SUMMARIZE(
'TeamsTable',
'TeamsTable'[Column1],
'TeamsTable'[Column2],
-- Add other columns as needed
)

-> Create local table and and this as DAX where

- TeamsTable is name of original Table, right?
- TeamsTable[Column1] etc. name of original column

I did it as you said

Copy_CQD = SUMMARIZE(
'CQD',
'CQD'[Second UPN],
'CQD'[Second Client App Version]
)
It worked but when I added 'CQD'[Second Client App Version] it timed out.
Have you an idea how to fultill the task?

Regards

JFM_12