Forum Discussion

jaredmartin's avatar
jaredmartin
Frequent Visitor
5 years ago
Solved

Power BI import to SQL?

I'm relatively new to Power BI and have figured out quite a bit so far.  I have transformed and imported an excel file into Power BI and can do my reporting/graphing.  I was wondering though if it is possible for me to take the transformed data and subsequently import it into MSSQL (either through Power BI or some other means).  Each excel file will have a months worth of data.  Since the source file is fairly complex and required a bunch of data transformations (pivots, unpivots, etc) to get it into a decent reportable format, I was hoping I could build up a SQL table which I could then query for historical trends, etc.

 

Thanks,

Jared

Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey jaredmartin ,

     

    by default not.

    I think it would work when you integrate a PowerApp that will just write the data to a SQL Server. Probably also with PowerAutomate it could work, but I didn't test that.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

4 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey jaredmartin ,

     

    by default not.

    I think it would work when you integrate a PowerApp that will just write the data to a SQL Server. Probably also with PowerAutomate it could work, but I didn't test that.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
  • jaredmartin's avatar
    jaredmartin
    Frequent Visitor
    5 years ago

    Thanks.  I found a few possible useful solutions on Youtube.  I'll also look at integrating PowerAutomate as well, as I forgot about that aspect.  Thanks!

    • selimovd's avatar
      selimovd
      Most Valuable Professional
      5 years ago

      Hey jaredmartin ,

       

      just because I'm curious, what was the solution you found?

       

      Thank you and best regards

      Denis

      • jaredmartin's avatar
        jaredmartin
        Frequent Visitor
        5 years ago

        Sorry for the delay. I ended up rethinking things and I was able to rearchitect my destination tables and better transform the source files. It isn't fully automated now but it isn't a terrible manual process to get us started.