Applies to Product - Microsoft Dataverse
What’s happening?
The customer is unable to connect to the new Snowflake connector in Power App, although the connection works in Power Automate and Dataflow.
Reason:
This arises because the customer needs to create a Virtual table first before using it in the canvas app. The Snowflake table cannot be used directly in the application.
Resolution:
- Create the Virtual table as per the documentation provided.
- Ensure that the Virtual table is created successfully before attempting to connect it in the canvas app.
- After creating the Virtual table, use the connection in the Power App to add this table as a data source.
- If there are issues with data retrieval or CRUD operations, check the external table in Snowflake for the following:
- Ensure that the external table has a primary key defined.
- Remove any duplicate records from the external table, as this can cause issues with data updates.
- For further assistance, refer to the document Snowflake - Connectors | Microsoft Learn