Forum Discussion
API credentials with gateway error
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 it
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.
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.