Informatica EDC profiling 10.4.1 Error - Could not create id creator for schema dbo and table due to missing row count result summary

Scenario: We want to integrate Azure SQL with Informatica EDC 10.4.1 and run profiling. 

Error: Integration and connection test was successful from the informatica Catalog Admin. but, when we run the resource, it fails.

Steps to Resolve:

• Go to Informatica Domain Admin web portal and make a new connection to Azure SQL
• In Metadata Access Properties, specify the connection string
• Connection String: jdbc:Informatica:sqlserver://<your server name>:1433;SelectMethod=cursor;DatabaseName=<your database name>;SnapshotSerializable=true;EncryptionMethod=SSL;HostNameInCertificate=*.database.windows.net;ValidateServerCertificate=false;CryptoProtocolVersion=TLSv1.2
• In Data Access Properties, specify the below:
• Provider Type: ODBC
• Use DSN: True
• Connection String: <Name of your DSN>
• Create a DSN entry for your Azure SQL in the Informatica > ODBC(version)>ODBC.ini file

• Make sure, you specify "EnableQuotedIdentifiers=1" otherwise the data preview and your profiling/mapping will fail.
• Informatica KB: https://docs.informatica.com/data-integration/data-services/10-2/installation-and-configuration-guide/connecting-to-databases-from-windows/connecting-to-a-microsoft-sql-server-database-from-windows/configuring-native-connectivity/rules-and-guidelines-for-microsoft-sql-server.html
• After your have created a DSN entry, specify the name in your Connection string of Data Access Properties. 

• Test the connection. 
• Go back to Informatica Catalog Admin and edit the Metadata settings.
• under common discovery options, set the source connection name to the connection that you created in the previous step.

• You are now all set.
• Go ahead and run the resource.

• this time, the profiling will work