Forum Discussion
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.
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
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.
