Forum Discussion

HxH's avatar
HxH
Icon for Advocate II rankAdvocate II
6 years ago
Solved

Copying data into a new table ignoring the data source

Hi everyone I have a PBIX file in which I uploaded a source for which I am not able to set the gateway connection. Since it doesn't need to be refreshed anyway what I want to do is copy the data int...
Need Help
Tutorial Requests
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi HxH ,

     

    Firstly, We can convert the entire text by Binary.ToText and Json.FromValue function:

     

     

    Then we create another Query after we copy the entire output text.

     

     

     

    After get the binary file, we can convert it to json then the table.

     

     

    At the last, we can expand all the column inside.

     

    At last, we need to change the type and name of columns and tables name as the same as the origin one to replace it (Please make sure you have a backup before change the query)

     

    Because this table is generate from constant text, it does not need to configure gateway in Service.


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi HxH ,

 

Firstly, We can convert the entire text by Binary.ToText and Json.FromValue function:

 

 

Then we create another Query after we copy the entire output text.

 

 

 

After get the binary file, we can convert it to json then the table.

 

 

At the last, we can expand all the column inside.

 

At last, we need to change the type and name of columns and tables name as the same as the origin one to replace it (Please make sure you have a backup before change the query)

 

Because this table is generate from constant text, it does not need to configure gateway in Service.


Best regards,