Forum Discussion

ercwebdev's avatar
ercwebdev
Frequent Visitor
6 years ago
Solved

URL escaping to get PWA subsites

Hi all, I'm struggling with a quirky little problem in Power BI that is causing a big problem. I came across this tutorial (which uses Power M Query) to access many subsites in SharePoint and return...
Need Help
  • Sergiy's avatar
    Sergiy
    6 years ago

    ercwebdev ,

    Hi Alan,

     

    Try this code:

    let
    Source = "https://mysitename.sharepoint.com/sites/pwa/project  -  name",
    uriPartsRecord = Uri.Parts(Source),
    result = uriPartsRecord[Scheme] & "://" & uriPartsRecord[Host] & uriPartsRecord[Path]
in
    result

     

    the result I get is

    https://mysitename.sharepoint.com/sites/pwa/project%20%20-%20%20name

     

    Does it help?

Sergiy's avatar
Sergiy
Resolver II
6 years ago

ercwebdev ,

Hi Alan,

 

Try this code:

let
    Source = "https://mysitename.sharepoint.com/sites/pwa/project  -  name",
    uriPartsRecord = Uri.Parts(Source),
    result = uriPartsRecord[Scheme] & "://" & uriPartsRecord[Host] & uriPartsRecord[Path]
in
    result

 

the result I get is

https://mysitename.sharepoint.com/sites/pwa/project%20%20-%20%20name

 

Does it help?

ercwebdev's avatar
ercwebdev
Frequent Visitor
6 years ago

Hi Sergiy,

Thanks for taking the time to provide a solution for this. It works as expected. But still can't seem to get the solution working to will have to investigate other areas.

Thanks,

Alan