Forum Discussion

martbov's avatar
martbov
Frequent Visitor
8 years ago
Solved

Change Redshift database in report

Hello everyone,   I've built a report in Power BI desktop with Amazon Redshift as its datasource. The report was built using a test database/cluster in Redshift and now that the report is complete,...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    martbov,

    There are two methods for you to change the data source.

    1. Go to File->Options and Settings->Data Source settings, then find your data source and click change data source.


    2. Right click your table, select "Edit query", then click Advanced Editor in the Query Editor of Power BI Desktop, change server and database in the source code in the Advanced Editor .

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

martbov,

There are two methods for you to change the data source.

1. Go to File->Options and Settings->Data Source settings, then find your data source and click change data source.


2. Right click your table, select "Edit query", then click Advanced Editor in the Query Editor of Power BI Desktop, change server and database in the source code in the Advanced Editor .

Regards,
Lydia

kevhav's avatar
kevhav
Continued Contributor
8 years ago

I also had this use case. And I discovered that the "Change Source..." button is not enabled, for my Redshift data source.

 

I just created this idea; please vote...

"Change Source..." for Redshift data sources