Data Translation: DeepL API asks for credentials in PowerBI Service, Web.Contents() Status 400

[alexrobe]

Hello PowerBI community,

I have a "DeepL API Free" Account and calling DeepL API locally in PowerBI Desktop works like a charm.
As soon as I upload to the web and want to schedule a refresh, I get asked for credentials, which seems I cannot overcome. I have entered my auth key and in the web tried all options besides "Service Principal".  "Anonymous" and "Standard" with my deepl-Account did not help.
Have you had any issues or proposals for this? Anything limiting from MS or DeepL side?

Thanks,
Alex

[Anonymous]

Hi, @alexrobe 

According to your description, you want to use DeepLAPI in Power BI service but the data validation is wrong, you can try to configure the gateway and keep the gateway on all the time and configure the schedule refresh settings to keep the data up-to-date.
Scheduled refresh link: Configure scheduled refresh - Power BI | Microsoft Learn

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[alexrobe]

Thank you for taking your time to reply!
Not sure if going via gateway connection for this web source would help my credentials issue, I anyway tried but the same error
So for my detailed error 

in Plain text:

Failed to update data source credentials: The credentials provided for the Web source are invalid. (Source at https://api-free.deepl.com/v2/translate.)Hide details

Activity ID:	0aae6397-3c5b-4615-b2ac-5e976fe9b911
Request ID:	2ef76e47-9a51-41d5-529a-90172e2d6022
Status code:	400
Time:	Mon Mar 18 2024 07:32:13 GMT+0100 (Mitteleuropäische Normalzeit)
Service version:	13.0.22872.56
Client version:	2403.2.18432-train
Cluster URI:	https://wabi-north-europe-i-primary-redirect.analysis.windows.net/ == Before: just direct web connection via gateway:  I tried But same result, even with my deepl account credentials entered. So the question remains: does MS allow the connection in web service or is it refused on the DeepL-side? What would be the solution / workaround? Thanks, Alex

[alexrobe · Accepted solution]

Here a solution for all others, who face a similar issue:
I put the translation function and all distinguished transformation steps into a Dataflow where I just could ignore the credentials and create an anonymous connection.
Then I simply reimported the Dataflow into my semantic model and as this is not a time critical report this is perfectly fine for this purpose.