transform data excel to sql server using power bi

• saptek9

  Ten Centuries

  Points: 1155

  More actions

  August 7, 2018 at 2:51 pm

  #357399

  I have lot of unstructured excel files which are with multiple tabs. I need to transform all this data to SQL Server tables. I am thinking of using Power query. Please advise.

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  November 20, 2018 at 9:12 am

  #2014108

  We can't see your data. How are we supposed to advise you?
  PowerBI is sort of cool, but the fact that you can't write back to sources BLOWS.

  use SSIS instead?