Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
VeeraPowerBIDev
Frequent Visitor

Complete URL Extarction from Sharepoint library Into Power BI

Hi Community,

 

I have a requirement where I am using the SharePoint library with some files preloaded and their metadata columns.

VeeraPowerBIDev_0-1694002517846.png

 

When I am trying to import the SharePoint library with V2.0 the URL column gives a trimmed URL,

Example:  "htttps.google.com/" is excluded but the remaining part is being extracted, let's say

 

"search?q=phito+pose&sca_esv=563061816&hl=en&tbm=isch&sxsrf=AB5stBi7YFzcianM-UojIz3_072BF_YV6w%3A1694002384073&source=hp&biw=1536&bih=739&ei=0Gz4ZKOrAsiehwP_4oqoAQ&iflsig=AD69kcEAAAAAZPh64AvMzI76g6s5g9hOwqIlZUfjc0BD&oq=phito&gs_lp=EgNpbWciBXBoaXRvKgIIADIFEAAYgAQyBRAAGIAEMgUQABiABDIFEAAYgAQyBRAAGIAEMgUQABiABDIFEAAYgAQyBRAAGIAEMgUQABiABDIFEAAYgARImBpQmwRYmxBwAXgAkAEAmAGVAaABngWqAQMwLjW4AQHIAQD4AQGKAgtnd3Mtd2l6LWltZ6gCCsICBxAjGOoCGCfCAgQQIxgnwgIIEAAYgAQYsQPCAggQABixAxiDAcICCxAAGIAEGLEDGIMBwgIEEAAYAw&sclient=img#imgrc=udgxHgWO1StZYM".

 

I know it's possible with Implementation 1.0, the complete URLs are extractible but the requirement is with Implementation 2.0.

 

Do we have a fix on how to completely extract the full URL? If yes, please help.

1 REPLY 1
christinepayton
Super User
Super User

It looks like the "FieldValuesAsText" column in 2.0 has the file path/name as one of the things you can expand (called "FileRef"). It doesn't include the site URL but you could concatenate that in Power Query. 

christinepayton_0-1694027164465.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors