Forum Discussion
API credentials with gateway error
Hi,apenaranda I am glad to help you.
Based on your description, it appears that the Power BI service is having issues when it tries to refresh data through the local data gateway using the credentials provided for the web source. The gateway connection fails and the reports on the service cannot be refreshed.
In fact getting data from the web via the API to produce reports is something I would recommend you do using dataflow.
I have discussed your issue with other members of the team. I have discussed your issue with other members of the team and believe that the dataflow you are currently trying to achieve through the Power BI Gateway is not applicable to the way you are getting data from the API.
This is because you need to provide a token for authentication when you get online data through the API, but the problem is that the token is dynamically changing and has a time limit. The gateway connection in power BI does not have the role of sending a token, it can only authenticate through a fixed authentication method that is set up, which means that there is no way to refresh the data through it. there is no good way to get the data through the gateway to refresh the data.
But the good news is that you can use dataflow form to get data, Creating new dataflows through API code, dataflow is a set of packaged data collection, you can directly use this dataflow to get data to create reports. By refreshing the dataflow to get the latest data, you can achieve the same effect as the gateway, instead of using the gateway connection to refresh the data.
Here are some of my suggestions:
Getting web data through APIs to create dataflows
Creating your report from a created dataflow
All you need to do is configure a refresh schedule for your dataflow and you can achieve the same results as if you were using a gateway refresh directly, with the benefit that the dataflow can be unified across multiple different data sources and is easy to manage.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello
I understand then that I should put my function that I had in this new flow as it is?
What I haven't mentioned before is that I use the following to bring (in this case they are states) in the form of a table connecting to the api (already with the token)
Where should I put the API call?
Hi,apenaranda. I am glad to help you.
You need to copy what you have in your power query into itI hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
To sum up, let's see if I'm doing it right.
1. The functions, both the one that requests the token and the one that connects to the API, I remove from Power BI Desktop
2. I create a dataflow for each of them, the one that asks for the token and the one that connects to the api
Is that so?
Hi,apenaranda I am glad to help you.
You just need to copy all the data source queries you executed in the power query into the blank query of the dataflow, and if you have multiple query steps you need to save them in a dataflow, making sure to keep them the same as in the power query, because the dataflow can be seen as another powerquery.I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.