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.

Share this:
Brian Grant
Brian Grant
briang@cgspro.com

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.



Ready to wrangle your data?