Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
jaredmartin
Frequent Visitor

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

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

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
 

View solution in original post

4 REPLIES 4
jaredmartin
Frequent Visitor

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!

Hey @jaredmartin ,

 

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

 

Thank you and best regards

Denis

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
Super User
Super User

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
 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.