Database - Switch from access to sql

[MM1984]

Hello together,

we have migrated some tables from Access to SQL Server. Is there any possibility to change the source from Access to SQL or do I have to recreate all the tables and measures ........

I have already tried in the editor to change the source from Access to SQL, but it did not work.:(

Marius

[MM1984]

Thank you. Your Video is perfect!

[v-chenwuz-msft · Accepted solution]

Hi @MM1984 ,

You can try to connect to sql first and configure the authentication information, then replace the data source part with the m language of sql connection in advanced.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.