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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.