Forum Discussion
PowerBI Table Open URL in a browser
Add "?&web=1" to the end of the file paths to force them to open in a browser. I did a video on this here, unsure if your source is the same but the calculation at about the halfway point: https://www.youtube.com/watch?v=yeIQ9jKln_I
Thank you for your response! This makes sense. Do you have any resource that you could direct me to for being able to do this in Power Query? The URLs are extracted from files that have links active so I had to run a macro within excel to extract them into a new column and this works as new data is added as well. Thanks a lot again!
Thank you for your response! This makes sense. Do you have any resource that you could direct me to for being able to do this in Power Query? The URLs are extracted from files that have links active so I had to run a macro within excel to extract them into a new column and this works as new data is added as well. Thanks a lot again!
Could you re-word your question for me? Not sure I'm grasping what you're asking - is it how to extract links from inside files without using an Excel macro? You could probably do that with Power Automate Desktop but if you already have it working in Excel I'd go with that. When I'm working with file URLs it's usually just the surface level path from the library in SharePoint, not inside the file content... but Power Automate Desktop can use regular expressions on files so presumably you could get anything that starts with your tenant URL and toss it to Excel with that.