Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Applying changes to imported data - reload

New to Power BI.  I imported all my data.  It took longer than I had hoped but figured now that the data was imported additional transformations/additions would go fast. I added one column to one of my tables and when I applied the changes it took a half hour to reload that table!  The table was not that big - less than 1 million records.

 

Am I guessing I am doing something wrong? No other tool would take this long. Thanks for any help,

 

Z

  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous，

    I am afriad that there is no option to change the behavior, this behaivor is by design.

    Regards,
    Lydia

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous,

    What is your data source? How many columns and rows in your tables? Please deselect the following option in the current PBIX file and check if the refresh time reduces.



    Regards,

    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks Lydia. The table has about 800K records and 100 columns.

       

      A question I have - I loaded from a SQL table via "Import".  I was thinking that now when I refresh or apply changes that it wouldn't try to go back and reload from the SQL table since the data was already imported. But it looks like it does go back to that connection and reloads?

       

      Steve

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Anonymous，

        When you add a column to table and click refresh in Power BI Desktop, it goes back to the connection. You can use SQL Server Profiler to capture the process.

        Regards,
        Lydia