Forum Discussion
Refreshing a Model with REST API POST Calls
- 3 years ago
1. mind mentioning the error message?
2. you can always choose to use a gateway and to skip the connection test on the gateway, although that is not recommended.
Hi , shuhn1229
As far as I understand, the API corresponding to the connection is normally accessed using anonymous mode. There should be a token string in the request header of your API, the general token is generated by another API, you can try to create the API that generated this token as a function in Power Query, and then generate a token to pass into your parameters. Then both use anonymous credentials to log in. If your API can only be accessed on your intranet, you may also need to download the on-premise data gateway on your computer to configure the corresponding credentials.
For more information, you can refer to :
Power BI Gateway | Microsoft Power BI
On-premises data gateway - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- shuhn12293 years ago
Resolver I
The datasource can only be accessed locally (e.g. mycompany.database.com) and as noted above, login requires a UN/PW that is provided by the AUTH header in my code. I'll look into the data gateway.
Steve