Search
Close this search box.

Migrating from an Excel to SQL Data Source in Power BI

Play Video

Stay up to date with the latest customer data news, expert guidance, and resources.

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:
Twitter
Facebook
LinkedIn

More Resources

Your Data, Analytics & AI Partner

Industry leaders choose Skypoint as their comprehensive and compliant Modern Data Stack Platform. A Certified Microsoft Solutions Partner, Skypoint Cloud turns siloed data into connected experiences.