Change data source settings for all queries in direct query mode

Hi cid255,

To change the data source connection string, you can locate to File -> Options and Settings -> Data source settings. Change the server name and database name to what you want.

Alternatively, you can change server name and database name via M query in Query Editor mode.

By the way, what did you mean "have a second query in my workbook thougg, that option is greyed out"? What was the workbook? And which option is greyed out? 

Do you want to change the data source to workbook which should be connected to in import mode? Since you have used live connection in current pbix file, it is not possible to connect/change to another data source with import mode.

There were multiple queries in your pbix file, you want to change data source settings for all of them at once, right? However, per my knowledge, it is not available to achieve that. 

Regards,
Yuliana Gu