Change datasource from MySQL to SQL Server

[dbravo]

Hi,

I have a report with a data source from a MySQL server. Recently, I have migrated the data to a SQL Server 2014 and I don't know how to change the data source for Power BI without mess up the current file.

How can I do this?

Thanks in advance.

[BILASolution · Accepted solution]

Hi @dbravo

An option to achieve this consists you need to change some code in "Advance Editor" inside Power Query.

On the ribbon: View --> Advance Editor

The window is similar to...

Here you can write your new SQL source.

I hope this helps

Regards

BILASolution

[Nusshaik]

Hello,

Do we have to chnage the source for all the tables in advance editor?

or do we have any option to update this in bulk.

Thanks,

Nusrath

[dbravo]

Hi @BILASolution,

It worked like a charm. Thank you.