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,

     

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

I don't understand what you mean by having a PBIX file with a table as the source. Tables for the most part should not be in PBIX files. I am not even sure if you can have a 3,000 record table in the PBIX file. I've never typed that much and have had paste failures in far smaller tables when playing around.

 

If it is external to the PBIX file, then what exactly are you trying to accomplish?