Forum Discussion

alexrobe's avatar
alexrobe
Advocate III
2 years ago
Solved

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

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

 

Need Help
  • alexrobe's avatar
    alexrobe
    2 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      alexrobe
      Advocate III
      2 years ago

      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's avatar
        alexrobe
        Advocate III
        2 years ago

        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.