Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Swap Data Source Settings from Existing Report

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

  • 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.

1 Reply

  • nandukrishnavs's avatar
    nandukrishnavs
    Community Champion

    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.