Forum Discussion
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
Community 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
Impactful 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
Community 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.