Forum Discussion
How to change the data source from SQL to Excel
If your table is identical (same names for each colunm)
then the best option is to go to the query editor
connect to the new table in excel
rename your old SQL table to TABLE_OLD
Rename yor new table to be exactly what the old one was
and then delete the old table.
when you then click close and apply the new table will be treated as if it was the old and all your measures and visuals will swap to this table as the relationships are based on table name
Hi Zoe Zhi,
Do I need to work again on the relationship part, If rename the columns and import the data in excel with same structure.
I observed that the relationship is remain same with table and fileds which was earliar assign to old tables.
According to the statement it should switch to latest once rename is done for all the relavant tables.
Please guide.
Thanks,
Maruti K
Hi Maruti_k,
I think you need to map the relationship manually after you create new table, relationship won't automatically be changed. But you don't need to change measure(after you re-map the relationship, measures will work correctly).
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.