Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.


Create table in PBI with a lot of data

Hello tod@s,

my query is as follows, I want to create a table in power bi and copy in it the data I have in an excel.

I created that table with the columns corresponding to the same ones I have in excel, then I copied and pasted the excel data into this new table in Power BI.

my problem is that I have 200,000 lines in EXCEL that I want to paste, the PBI tells me that I can only paste 3000 cells at a time, so I have to manually repeat COPY / PASTE many times until I complete the PASTE of all the data.

1- Can you think of any way to paste this data in one go in PBI?

2- is there any way to for example, link the excel table to the GDP and then dump it into my new table created in PBI?

3- Is there a way to convert a linked table to a local table in PBI?

Thanks a lot

Helper I
Helper I

Found this answer somewhere else: When you open Query Editor in power bi desktop, select the table that you do not want to refresh, right click it and disable Include in report refresh (it is active by default), close and apply Query Editor and the table will not refresh when the report is refreshed.image.png

Community Support
Community Support

Hi @Syndicate_Admin ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards

Community Support
Community Support


Maybe you could try to import data to sql: 


And when you import data from excel,you also still could connect to sql.


Best Regards


Super User
Super User

@Syndicate_Admin Question, why are you not just importing the data from Excel into Power BI?

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

it is because it is a statistical table whose data does not change so I do not need to synchronize it frequently, I need to cross it with other SQL tables.

any idea to import it easily?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors