Forum Discussion

cid255's avatar
cid255
New Member
9 years ago

Change data source settings for all queries in direct query mode

Hi,   I want to use the data source settings to change the server and dbname for all my queries on will. As soon as I have a second query in my workbook thougg, that option is greyed out, even if ...
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi cid255,

 

However, I didn't encounter the problem as you described. I loaded two queries into desktop from the same data source/database, I was still able to change the data source settings. The option was not greyed out.

 

 In your scenario, does this problem occur to other pbix files?

 

Regards,
Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi are you able to resolve this. I have one of my report in which my change source option has been grayed out. It works fine in other reports for same datasources.

 

Is there any limitations to use this change source option in datasource settings?

 

Regards,

Pradeep Reddy