transform data excel to sql server using power bi

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

  • 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 1 (of 1 total)

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