Web URL not properly recognized as valid Refreshable Source

Hi Grumelo ,

What are you using? Power BI Report Server or Power BI Service?

If you are using Power BI Report Server, it is not supported to refresh SharePoint Online data. For the list of supported data sources in Power BI Report Server, please check: 

Power BI report data sources in Power BI Report Server - Power BI | Microsoft Docs.

If you are using Power BI Service, it is needed to use Relative Path to refresh in Power BI Service. Try this:

Json.Document(Web.Contents("https://<sharepoint site url>/_api/",[RelativePath = "sp.userprofiles.peoplemanager/getpropertiesfor(@v)", Query = [#"@v"="'<user account name>'"], Headers=[Accept="application/json"]]))

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.