Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Solved! Go to 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.
Thank you. Your Video is perfect!
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!