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 ...
  • 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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Doesnt that defeat the pupose of importing the data? Isn't there a way to import the data and use the data as is without having to reconnect?

     

    Thanks for the help on this. 

     

    Steve

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous，

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

      Regards,
      Lydia