cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
brinky Helper II
Helper II

One Drive address

Hello everyone,

 

First of all not sure if I should ask in Poer BI community.

 

I'm having an issue with the One Drive address when refreshing data, I do know the reason behing but not sure if I can solve or go around it.  I use Power BI from my office desktop computer and I also use from my latop. When I'm working on my laptop and need to refresh I always have to change the source address C:\Users\brin\********\*******\****.xlsx address to my laptop address

C:\Users\slav\********\*******\****.xlsx

 

Is there a way I could juts refresh instead of changing the source address?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
mussaenda Solution Sage
Solution Sage

Re: One Drive address

One workaround for this is by putting the file in a shared drive. From there you will no longer need to change the address of the source always.

 

or, check this link

View solution in original post

2 REPLIES 2
Highlighted
mussaenda Solution Sage
Solution Sage

Re: One Drive address

One workaround for this is by putting the file in a shared drive. From there you will no longer need to change the address of the source always.

 

or, check this link

View solution in original post

Community Support
Community Support

Re: One Drive address

Hi @brinky ,

Maybe you can take a look at the following blog about to use power query to get the current username, then you can parameterize your connection string and use extracted value to replace username part.

4 ways to get USERNAME in Power Query

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors