This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 21%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
I was trying to create a linked service to a Google Ads account. I have obtained the Google Developer token through Google Ads and created a Google API project with Google Ads API.
But I am getting the below error when testing the linked service.
ERROR [HY000] [Microsoft][GoogleAds] (30) Error with HTTP request, response code: 400. Message: Version v12 is deprecated. Requests to this version will be blocked.
ERROR [HY000] [Microsoft][GoogleAds] (30) Error with HTTP request, response code: 400. Message: Version v12 is deprecated. Requests to this version will be blocked.
would appreciate any guidance on solving this issue?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hi MORA_160447G_Malshini Nissanka
Welcome to Microsoft Q&A platform and thanks for posting your question here.
It seems that you are using an outdated version of the Google Ads API, which is no longer supported by Google. According to the, version v12 was deprecated on September 27, 2023, and requests to this version will be blocked. You need to upgrade to a newer version of the Google Ads API, such as v15, which is the latest stable version as of November 2023.
Here are the steps to migrate your linked service to the new version of the Google Ads API:
I hope this information helps you resolve the issue. Let me know if you have any further questions or concerns.
Hi@MORA_160447G
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Hi@MORA_160447G
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Hi Harishga,
I am trying this in Azure Synapse Analytics and I use the default GoogleAds connector available under LinkedServices. There's no option to select a version.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 50%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB3%3C/text%3E%3C/svg%3E)
I am having same issue, this has worked for a year and started failing 11/17
Error code9603
Details ERROR [HY000] [Microsoft][GoogleAds] (61) API Connection Failed. Bad Request. HTTP Response code: 400 ERROR [HY000] [Microsoft][GoogleAds] (61) API Connection Failed. Bad Request. HTTP Response code: 400
Activity ID 444be850-8c71-45be-a36b-0805dc2883bf
Hi MORA_160447G_Malshini Nissanka,
I agree that this issue looks strange, and I wasn't able to reproduce this issue. If you have a support plan, could you please file a support ticket for deeper investigation and do share the SR# with us? In case if you don't have a support plan, please let us know here.
There has been no response.
We have opened a ticket with Microsoft Support with Tracking ID: 2311300040013438.
@MORA_160447G
We are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 86%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
I have the same issue when using the Google Ads connector in Azure Data Factory.
I can recreate the error by using the following URL in Postman:
https://googleads.googleapis.com/v12/customers/xxxxxxxxxx/googleAds:searchStream
When I change this into the following URL, I get the correct response in Postman:
https://googleads.googleapis.com/v15/customers/xxxxxxxxxx/googleAds:searchStream
I hope this issue can be resolved.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 0%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBV%3C/text%3E%3C/svg%3E)
We seem to be having the same issue. Do you already have any update from the internal team?
Hi BobGang-3117
whether the issue has been resolved with the help of support ticket. If yes, please share the solution so that it will be helpful to other community members.
The only response was to try using SHIR, which I responded please speak with team responsible for coding the linked service.
Just received this message:
Hello Team,
Greetings!
I will check with them once again and let you the update.
Thank you.
Regards,
Arcilla
Support Engineer | MS Bigdata & AI
Customer Service & Support - Data & Enterprise Cloud
*Email: v-arpinto@microsoft.com
Working hours: 6:00 PM – 3:00 AM IST (UTC+5:30) (Mon – Fri)
Alternate contacts if I am not available:
Technical Advisor: Chiranjeeb Nayak (v-cnayak@microsoft.com)
Ops Managers | Uday Kiran (v-sekiran@microsoft.com)
Managers | Naveed Hussain (v-shahussain@microsoft.com)
Team Distro | datamovementteam@microsoft.com
Microsoft update the connector 12/14 click here
After configuring the new linked service using v15, I realized I needed a new refresh token click here
Hi @BobGang-3117
I'm glad that you were able to resolve your issue.
This broke again, v15 was deprecated 9/30. I update to v17 and added new refresh token but getting this error Test connection operation failed.
Failed to open the database connection.
Fail to read from Google Ads.
Error:"unauthorized_client", Description:"Unauthorized", Uri:""