Migrating from an Excel to SQL Data Source in Power BI

Working off of an Excel data dump can be a great way to get started building a report while the more official SQL table gets built. The problem is that when you are done, repointing from Excel data to SQL data is never as easy as you want it to be. The columns need to be exactly the same for the migration to work yet there’s always at least one column with the wrong name messing everything up.

 

In this video we show you a technique to prep your SQL query to ensure that it matches up with the Excel version that all the other report references are based on. This will make for a nice smooth transition and reduce the amount of guesswork involved.

Brian Grant

Brian Grant

Brian Grant is a masterful Senior Analytics Consultant by day, and a Power BI legend by night. A passion for Power BI drove him to holistically master the tool from all three perspectives: M, DAX, and the visualization layer. Brian is a constant teacher who leads Power BI training sessions, while sharing his wealth of expertise through video and blogging resources.
SHARE THIS
Share on twitter
Share on facebook
Share on linkedin
Share on email
RELATED POSTS

Subscribe

Subscribe to CSG. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.

Ready to wrangle your data?