{"id":84706,"date":"2024-08-12T11:55:45","date_gmt":"2024-08-12T18:55:45","guid":{"rendered":"https:\/\/www.dcac.com\/?p=84706"},"modified":"2024-08-12T12:00:58","modified_gmt":"2024-08-12T19:00:58","slug":"power-automate-and-azure-sql-db-for-mysql-flex-server","status":"publish","type":"post","link":"https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/","title":{"rendered":"Power Automate and Azure SQL DB for MySQL Flex Server"},"content":{"rendered":"\n

If you are using Azure SQL DB for MySQL Standalone server and upgrading to MySQL Flex server and using Power Automate, you may see an error message from your Power Automate flows if you are using a Data Gateway. The error message that you’re getting could look something like this.<\/p>\n\n\n\n

An error happened while reading data from the provider: 'Character set 'utf8mb3' is not supported by .Net Framework.' inner exception: An error happened while reading data from the provider: 'Character set 'utf8mb3' is not supported by .Net Framework.' <\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
The problem in my case that was causing this issue was an older driver on our data gateway. It seems that for Power Automate to use a data gateway to connect to Azure SQL DB for MySQL, you’ll need a newer MySQL Driver installed<\/a> on the Data Gateway server. We had 8.0.15 installed, and the error message went away when we upgraded to 8.4.0<\/a> (the current version as of this post being written). The annoying part of this is that the database on the flex server and the stand-alone server was exactly the same database. To move the database from the standalone server to the flex server, we simply took a MySQL Dump of the standalone server and imported that into the Flex server. So, everything in the database was the same, but apparently, the connecter didn’t like anything about the new Flex server without a driver upgrade.<\/p>\n\n\n\n
Once the driver was upgraded all the flows which use that connector for the MySQL database started working as expected.<\/p>\n\n\n\n
Denny<\/p>\n","protected":false},"excerpt":{"rendered":"
If you are using Azure SQL DB for MySQL Standalone server and upgrading to MySQL Flex server and using Power Automate, you may see an error message from your Power Automate flows if you are using a Data Gateway. The error message that you’re getting could look something like this. The problem in my case […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[551,580],"tags":[],"class_list":["post-84706","post","type-post","status-publish","format-standard","hentry","category-blog","category-mysql"],"yoast_head":"\nPower Automate and Azure SQL DB for MySQL Flex Server – Denny Cherry & Associates Consulting<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Automate and Azure SQL DB for MySQL Flex Server – Denny Cherry & Associates Consulting\" \/>\n<meta property=\"og:description\" content=\"If you are using Azure SQL DB for MySQL Standalone server and upgrading to MySQL Flex server and using Power Automate, you may see an error message from your Power Automate flows if you are using a Data Gateway. The error message that you’re getting could look something like this. The problem in my case […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Denny Cherry & Associates Consulting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DennyCherryAssociatesConsulting\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-12T18:55:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-12T19:00:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dcac.com\/wp-content\/uploads\/2021\/12\/DCAC_META-IMG001.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Denny Cherry\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@mrdenny\" \/>\n<meta name=\"twitter:site\" content=\"@dcacco\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Denny Cherry\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/\",\"url\":\"https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/\",\"name\":\"Power Automate and Azure SQL DB for MySQL Flex Server – Denny Cherry & Associates Consulting\",\"isPartOf\":{\"@id\":\"https:\/\/www.dcac.com\/#website\"},\"datePublished\":\"2024-08-12T18:55:45+00:00\",\"dateModified\":\"2024-08-12T19:00:58+00:00\",\"author\":{\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/cbc8485c710a3eee0e50dcfa9518636e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dcac.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Automate and Azure SQL DB for MySQL Flex Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dcac.com\/#website\",\"url\":\"https:\/\/www.dcac.com\/\",\"name\":\"Denny Cherry & Associates Consulting\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dcac.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/cbc8485c710a3eee0e50dcfa9518636e\",\"name\":\"Denny Cherry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ccade9c22d8686e4b5a46cb49a636eea?s=96&r=x\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ccade9c22d8686e4b5a46cb49a636eea?s=96&r=x\",\"caption\":\"Denny Cherry\"},\"sameAs\":[\"https:\/\/x.com\/mrdenny\"],\"url\":\"https:\/\/www.dcac.com\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power Automate and Azure SQL DB for MySQL Flex Server – Denny Cherry & Associates Consulting","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/","og_locale":"en_US","og_type":"article","og_title":"Power Automate and Azure SQL DB for MySQL Flex Server – Denny Cherry & Associates Consulting","og_description":"If you are using Azure SQL DB for MySQL Standalone server and upgrading to MySQL Flex server and using Power Automate, you may see an error message from your Power Automate flows if you are using a Data Gateway. The error message that you’re getting could look something like this. The problem in my case […]","og_url":"https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/","og_site_name":"Denny Cherry & Associates Consulting","article_publisher":"https:\/\/www.facebook.com\/DennyCherryAssociatesConsulting\/","article_published_time":"2024-08-12T18:55:45+00:00","article_modified_time":"2024-08-12T19:00:58+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.dcac.com\/wp-content\/uploads\/2021\/12\/DCAC_META-IMG001.jpeg","type":"image\/jpeg"}],"author":"Denny Cherry","twitter_card":"summary_large_image","twitter_creator":"@mrdenny","twitter_site":"@dcacco","twitter_misc":{"Written by":"Denny Cherry","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/","url":"https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/","name":"Power Automate and Azure SQL DB for MySQL Flex Server – Denny Cherry & Associates Consulting","isPartOf":{"@id":"https:\/\/www.dcac.com\/#website"},"datePublished":"2024-08-12T18:55:45+00:00","dateModified":"2024-08-12T19:00:58+00:00","author":{"@id":"https:\/\/www.dcac.com\/#\/schema\/person\/cbc8485c710a3eee0e50dcfa9518636e"},"breadcrumb":{"@id":"https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dcac.com\/2024\/08\/12\/power-automate-and-azure-sql-db-for-mysql-flex-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dcac.com\/"},{"@type":"ListItem","position":2,"name":"Power Automate and Azure SQL DB for MySQL Flex Server"}]},{"@type":"WebSite","@id":"https:\/\/www.dcac.com\/#website","url":"https:\/\/www.dcac.com\/","name":"Denny Cherry & Associates Consulting","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dcac.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dcac.com\/#\/schema\/person\/cbc8485c710a3eee0e50dcfa9518636e","name":"Denny Cherry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dcac.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ccade9c22d8686e4b5a46cb49a636eea?s=96&r=x","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ccade9c22d8686e4b5a46cb49a636eea?s=96&r=x","caption":"Denny Cherry"},"sameAs":["https:\/\/x.com\/mrdenny"],"url":"https:\/\/www.dcac.com\/author\/admin\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/84706","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/comments?post=84706"}],"version-history":[{"count":3,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/84706\/revisions"}],"predecessor-version":[{"id":84709,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/84706\/revisions\/84709"}],"wp:attachment":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/media?parent=84706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/categories?post=84706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/tags?post=84706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}