Forum Discussion

Heinrich's avatar
Heinrich
Post 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
Heinrich's avatar
Heinrich
Post Partisan
2 years ago

Hello Saudansari

Dataflow is not enabled in our company
The Power BI File is allready available at Microsoft Site and allready opened. 
Change the Storage Mode and how do I have to import it?

I am looking for a solution in DAX is this possible?
Is it possible to have a DAX query that pulls the data and copies it to a local table?
Regards
JFM_12

saudansari's avatar
saudansari
Helper 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
    Post 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