how to change redshift Database name in power bi with direct query

[dilip]

hi i am using redshift  with direct query option to create report 

but now when i am trying to change DB name from query window 

i am getting this error - 

https://ibb.co/bUyrgT

failed to save modifications to the server . error returned : all partitons using directquery mode with full dataview must query the same data source 

any suggestion to solve this issue . 

[v-yuta-msft]

Hi dilip,

Based on your description, are you change your data model in query editor and after clicking "closed&applied" the error happends, right? If it is In this senario, you should remove all of the old report in report level and try again. If it isn't in this senario, please empty the datasource connections and connect to redshift database again.

Regards,

Jimmy Tao

[dilip]

do you mean deleting all the pbix file ? 

[v-yuta-msft]

Hi dilip,

You don't need to delete PBIX file. What should be deleted is the chart which contains fields in old datasource in the report level. In addtion, if this error still happens, open advanced editor and modify the new datasource name and the related tables.

Hope this is helpful to you.

Jimmy Tao

[dilip]

hi 

Passed Case

1 connected to redshift database and selected 1 table in direct query mode saved the pbix file .

2 changed the database name from advance query editor and saved  and applied .

DB name changed sucessfully . 

Failed Case

1 connected to redshift database and selected 2 table in direct query mode saved the pbix file .

2 changed the database name from advance query editor for both the table  and saved  and applied .

given  below error - 

failed to save modifications to the server . error returned : all partitons using directquery mode with full dataview must query the same data source 

Note - my bi version- Version: 2.58.5103.501 64-bit (May 2018)

and i only added table no reports created  to perform above test case .