Can my dashboard remain unchanged if I change my data source from XLSX to SQL Server, if all the columns and values are the same?

Hey all,

I am currently working on an Analysis from an excel file, but I eventually want to connect the same Analysis to a SQL Server DB. Will it retain my Analysis, provided ALL the columns are exactly the same?

Looking forward to answers on this one. Thanks!

Yep you can do it!

You just need to click replace and then substitute in the dataset from your SQL Server DB.

It will be exactly the same only if you name the columns the exact same, and they are the same data types (string, numeric, dates, etc…)

Yes can. No issue.