transform data excel to sql server using power bi

  • saptek9

    Ten Centuries

    Points: 1042

    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: 62365

    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?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply