Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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. 

  • Hi Anonymous ,

     

    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.

     

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      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.