Forum Discussion
Solved
Remove existing DataSource
Hi, if i change a data source for example from one database to another database by editing the M Script, the previous used database connection still exists because when i publish the pbix to powe...
I was facing the same issue as the OP - and didn't want to break the URL that a lot of our users have bookmarked by deleting and re-publishing. I also couldn't see the additional source anymore in Transform Data > Data Source Settings so changing the source wasn't a viable option. What I tried instead was going to File > Options > Data Load > Data Cache Management Options and I cleared the cache and republished. This removed my extra source that was no longer valid and causing refresh failures.
thanks, that worked for me!
