Copying/Pasting Data in to PBIX File, instead of pointing to CSV File.

[F_Reh]

Good Morning,

I have a Dashboard with a Data source pointing to a very simple CSV File in my local drive.

I wish to change things so that I don't have to consistenly rely on valid reference to the local file, but simply copy-paste the table data in to the PBIX.

But the issue is if I delete the Table already in the PBIX file it will break existing links (even if re-creating the table with exactly the same name via the 'Enter Data' method). My understanding is that a reconstructed version will not be recognised as the original Table.

Kindly advise, if I can work with the existing Table (as it is in the PIBIX file), and somehow "erase the reference to the local file and simply paste in the data from the file itself", to save me from having to delete this and having to completely reconstruct it along with re-doing all the relationship links.

Kindly advise...

[pankajnamekar25]

Hello @F_Reh 

let

    Source = Table.FromRecords({

        [Column1="A", Column2=1],

        [Column1="B", Column2=2],

        [Column1="C", Column2=3]

    })

in

    Source

Use above code and entirre your data in Power Query then rename the query to the orginal CSV name and disbale load of orgina; CSV 

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[MFelix · Accepted solution]

Hi @F_Reh ,

Do the process of the copy+paste on Power Query then go to the advance editor copy the advance code and paste it on the advance editor of the one you have connected to the csv file, should work properly without loosing all your relationships and other thigns, as long as you keep the name and number of columns.