move data source to onedrive for business

[ThomasDay]

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

[Greg_Deckler]

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]

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]

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.

[ThomasDay]

Oh, crikey--sorry, that was staring me in the face.  Thanks!  Tom

[ThomasDay]

Gosh, I want to use a onedrive url for each file, don't I?  

• or do I use the sync'd file from my ssd  
• If use the url..I'm not sure how to morph the file path to a url muchless figure out the (sharing) privleges part.  

So I guess that's the next layer question if I don't just use the sync'd file.  

I must be missing a whole section of how-to's here, so steer me that way if I'm going over obvious things here.  Do I need a "gateway" or some such thing?

Thanks,

Tom

[konstantinos]

@ThomasDay Yes you need to change the url in all queries to point to onedrive files. 

I had written a post regarding url paths

https://medium.com/@Konstantinos_Ioannou/onedrive-powerbi-desktop-use-valid-paths-to-import-data-sto...

but also if you search the community there are at least 2 great posts for the subject

[ThomasDay]

Thank you, this looks great.  (Turns out there are lots of OneDrive issues when I searched.  Sure didn't see this but I will say I've read a bunch of your posts in the past month by clicking on your profile.  Ironically, searching well requires domain knowledge that rookies often don't have...so the searches are clumsy.  I suppose I could have searched on people who provide the many and varied solid answers to find it.)  Anyway, thank you again.  Tom