You would need the power bi report to be in a Fabric/premium capacity workspace and Capacity setting XMLA Endpoint = Read (or Read/Write)

Any specific reason why via XMLA endpoint?
Via the REST API : Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Learn, you can even query the semantic models within pro workspaces