How to Switch Your Power BI Table to a Different Data Source Type Without Breaking Anything

If your model started out in Excel, but now you are forced to connect to data in a database, you do not have to stress out. Yes, unless you watch this video, you will have to rebuild everything, but if you do watch this video, I will show you how you can move your table(s) from one data source type to another without having to break anything.

The steps to switch are the following:

  1. Bring the new table in (do not delete the old one – NEVER delete the old one)
  2. Disable load for the new table
  3. Make the new table look as close as possible to the old table (if you can’t, don’t stress, as long as the old column names can still be found – nothing will break)
  4. Go to Advanced Editor in Transform Data window and copy the code (M code for the techies) into your clipboard then hit escape
  5. Now go to Advanced Editor for the old table and replace its code with the new code you had just copied into your clipboard, then hit OK
  6. Do it for all tables you need to switch and then hit Close and Apply
  7. You are done, everything should still work measures will still work as long as the column names stayed the same and your relationships should not be broken

Please watch the video for more details:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s