Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
wassim
New Member

Huge Data upload

Hello,
I have an issue when uploading my data. In fact, I have a huge table and the upload takes a long time so I am asking if there is a solution to upload the whole table as block (and not line by line) or any other solution. 
The second question is : If I have already upload data and create a model is there a possibility to add another column (for example) and keep the same links. 

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @wassim ,

 

As data in power BI are highly compressed. You can refer to the third-party bolg to know how the engine work in power bi. So to import a table as block is not possible. Please refer to this blog to find the ways to optimize your data model.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

2 REPLIES 2
v-frfei-msft
Community Support
Community Support

Hi @wassim ,

 

As data in power BI are highly compressed. You can refer to the third-party bolg to know how the engine work in power bi. So to import a table as block is not possible. Please refer to this blog to find the ways to optimize your data model.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Hi @v-frfei-msft
Thank you for your response.
What about the second question? Is it possible to imort new columns to the same model without causing any problem?
For example I have a table in my source data and I have imported only 3 columns and I have created the model . Is it possible at that time to import other columns and add them to the same model without reapting from the beginning.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!