Data Model scenario in Power Query

[dan1234]

Hi everyone,

I was hoping to get some guidance on a data model scenario that I need to solve.

A data dump from a legacy system is in an Excel file and needs to be kept inside a Power BI file for historical reference purposes.

The ask is that this excel data dump can’t be stored inside a SharePoint or any other location other than the Pbix file.

I have tried to create a data table in Power query so that I can dump the data records here and it will have no linkage to SharePoint site or any storage option, however, this dataset has nearly 60,000 records and so there is no direct copy and paste option. I have to make data samples and input set by set.

Is there any better or easier way to do this rather than copy and paste a set 3000 records each.

I have thought to import the model and disable the load option however it is not working for the ask of not to store in any other location other than Pbix file.

Appreciate any better suggestions.

Attaching the sample data and screen shots of the options I tried for for quick reference 

[Idrissshatila]

Hello @dan1234 ,

so you copy the data you need then click on the left corner and click Ctrl + V and it would be pasted all.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[dan1234]

Hi @Idrissshatila ,

Thanks for getting back to me.

That option is not allowing to do copy and paste once if your data is having rows more than 3000.

The data that I have is about 60000 rows.

Any way that you are aware of doing this please do let me know.