Forum Discussion
HxH
Advocate II
Advocate IICopying 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...
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,
