Forum Discussion
How do I get Power BI REST API data into a Power BI report?
1. You have two ways of connecting to power query one is using a Power BI Connector which will be present as a mez file in your local directory but cannot be refreshed in service without a gateway. Refer the below link
Power BI REST API Connector — The Power User
2. The other way is refreshable in service and you will need a service principal with necessary scopes to call the API. Please check the below blog on how to call Power BI Rest APIs within power query using Service Principal
Connect with Power BI to the Power BI REST API with a Service Principal – PBI Guy
Thanks,
Hi jarwest ,
Following up to see if your query has been resolved. If any of the responses helped, please consider marking the relevant reply as the 'Accepted Solution' to assist others with similar questions.
If you're still facing issues, feel free to reach out.
Thank you.