Forum Discussion

ThomasDay's avatar
ThomasDay
Icon for Impactful Individual rankImpactful Individual
10 years ago

move data source to onedrive for business

Hello All,

 

I've developed a very large data model on premises using powerbi desktop and local drives.  I then have migrated the model to powerbi.com and it's working well.  I'd like to now move the files from the queries from my onpremise data to my onedrive for business account (same business account) .  I don't see a way to edit my model queries for each data source (about 18) to change the data paths.

 

I feel certain this is a rookie problem.  Any help is appreciated.

Tom

7 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Well, generally you go into the Advanced Editor and you can edit the Source line to point to your new source. However, I do not believe that there is a connector for One Drive for Business in Desktop, only in the Service so that is going to present a problem. 

    • ThomasDay's avatar
      ThomasDay
      Icon for Impactful Individual rankImpactful Individual

      The model is there right now...presuming powerbi.com subscription is the service you refer to...created in desktop but moved up there.  I can't find the advance editor you refer to anywhere having looked under the menus, elipses, gears, and so on.  Where might it be?  Is there another level of powerbi.com I need to have?  Thanks!  Tom

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion

        The Advanced Editor is not available in the Service, only in the Desktop when you Edit Queries, go to View tab and choose Advanced Editor.