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,
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,
Hey Jai, I think the first solution is actually the solution being used to build this old report, thanks for finding this! I don't know if this solution works anymore, I'm having trouble authenticating, and I'd imagine that's why this report started failing to begin with. Does the person who sets this up need to be a PBI admin?
If I can't get it working I'll explore the second option. Thanks!
jarwest The first method will only work If you have the .mez file in your local directory.
Hey Jai, sorry for the delayed response, but this did end up working. I already had it in the proper folder I just didn't have proper permissions for the API itself. I'm currently struggling with getting it to refresh in PBI service, would it just be an issue of getting the data source into a gateway?
Thanks again! I did go ahead and mark your answer as the solution