Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |