Seeking Power Query Example for Translation Using Public API

Question

Hello everyone,

I’m working on a project where I need to translate text in Excel using Power Query (PQ) and a public API. I’m looking for examples or templates that demonstrate how to set up Power Query to use public translation APIs effectively.

• Power Query M Code: I need a working example of Power Query M code that translates text using a public API.
• Public APIs: Preferably, APIs that do not require authentication or are freely accessible, such as LibreTranslate, Apertium, or others.
• Excel Integration: How the solution is integrated into an Excel workbook using Power Query.
• 404 Errors: I’ve tried using some endpoints but received 404 Not Found errors.
• Response Handling: I’m unsure how to handle different response formats from the APIs (e.g., JSON, plain text).
• Attempted to use Apertium API, but faced issues with correct endpoints and response handling.
• Checked various public translation APIs but haven’t found a working example yet.
• Translation Direction: Example code for translating from French to English or any other common language pairs.
• Excel Version: I’m using Excel 365 but would appreciate examples that work across different versions.

If anyone has a working example or can guide me to a detailed tutorial or post where this has been implemented, I would greatly appreciate it!

Answer 1

I'd suggest you create a new thread on Power Query Forum whih is special channel to handle Power Query related questions.

Welcome to the Power Query forum! - Microsoft Fabric Community

Thank you for your understanding.