Swap Data Source Settings from Existing Report

[Anonymous]

Hi,

I've connected to my Redshift data using the native connector in Power BI Desktop. But I've realised it's missing some information needed to refresh it. I've gone into my existing report to add in this new data connect, but all my queries are linked to the old Data Source Settings.

When I option the Data Source Settings window, I can't delete the old settings because they're attached to existing queries. But I don't know how to change my queries to use this new connection. The "Change Source" button is greyed out, as is the "Delete" option.

Any ideas on how to swap Data Source Settings for my existing queries without having to rebuild everything from scratch?

Thanks,

Mark

[nandukrishnavs · Accepted solution]

@Anonymous  Goto advanced editor of Old queries and change the required connection settings as per the new query. After that you can delete new query as you already made changes to the old queries.