Get MS Project Sharepoint List Data using Web connection

Hi , I understand we can connect to SPO List using Sharepoint Online List connector. But is it possible to use Web connector ? I would like to use RelativePath function and parameterise the url. This is mainly to circumvent the Dynamic Data Source error in Power BI Service. 

"This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources."

https://xyz.sharepoint.com/sites/pwa/Project%20Online%20Project%20Example/Lists/Risks/All%20Items%20Datasheet.aspx

https://xyz.sharepoint.com/sites/pwa/Project%20Number2/Lists/Risks/All%20Items%20Datasheet.aspx

https://xyz.sharepoint.com/sites/pwa/Project%20Number3/Lists/Risks/All%20Items%20Datasheet.aspx

The idea is just to extract all entires of Risks from each projects. 

Any help will be appreciated