Power BI import to SQL?

[jaredmartin]

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

[jaredmartin]

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]

Hey @jaredmartin ,

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

Thank you and best regards

Denis

[jaredmartin]

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. 

[selimovd · Accepted solution]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic