It doesn't appear to be accurate that PBIRS paginated reports can only access Microsoft daata-sources.
https://learn.microsoft.com/en-us/power-bi/report-server/connect-data-sources specifies: "Paginated report data sources in Power BI Report Server match those in SQL Server...