Create table in PBI with a lot of data

[Syndicate_Admin]

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

[tormi]

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.

[v-luwang-msft]

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
Lucien

[v-luwang-msft]

Hi 

Maybe you could try to import data to sql:

https://solutioncenter.apexsql.com/how-to-import-data-in-sql-database-from-excel/ 

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

Best Regards

Lucien

[Greg_Deckler]

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

[Syndicate_Admin]

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?