Forum Discussion

majort's avatar
majort
New Member
11 years ago
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...
  • jeremyfirth's avatar
    jeremyfirth
    11 years ago

    had this same issue when I created a link to a file on a mapped network drive initially, then later changed it to the full network path to the file.

     

    Both data connections were showing up when I either published it to PowerBI.com or when I went to PowerBI.com and tried to pull the file instead. 

     

    I ended up deleting it from PowerBI.com, re-downloading and installing Personal Gateway, then pulling the file into PowerBI.com using Get Data.

     

    Kind of a pain, but it worked. It was a solution offered by a Microsoft employee in another thread.

catiewilliams17's avatar
catiewilliams17
Advocate I
3 years ago

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.

  • DoubleJ's avatar
    DoubleJ
    Solution Supplier
    1 year ago

    thanks, that worked for me!