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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
11 years ago

In Power BI Desktop, File | Options and Settings | Data Source Settings

 

Highlight the data source and hit "Delete"

  • majort's avatar
    majort
    New Member
    11 years ago

    The problem is that in the data source settings only 1 connection is listed. When i upload the pbix to the service, 3 connections are listed in the data sets schedule settings.

    • jeremyfirth's avatar
      jeremyfirth
      Icon for Advocate II rankAdvocate II
      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.

      • jimmyhaley's avatar
        jimmyhaley
        Icon for Advocate II rankAdvocate II
        11 years ago

        So...this is not a solution, this is a workaround.

         

        The problem remains that if you delete a datasource from your PowerBI Desktop file, it remains (forever, as far as I can tell) in the upload.  Deleting a dataset and reuploading it is a huge pain when you have a minor dataset tweak (such as moving the dataset to new drive or different folder).  This needs to have a true solution before it is marked as solved.