Power APPS Snowflake connector showing Error Table Couldn't Loaded correctly and Resource not Found

(0) Share

Report

Posted on by MP-27111159-0

hi Team,

I have created Deamon Apps to connect the snowflake , with all detail Client id, Tenant Id, Secrete Id WH, Schema, Role Details I am trying to connect the Snowflake DB, It showing me as error as Table couldn't Load Correctly / Resource Not Found.

With Same detail I am trying to connect the Snow SQL it successfully connected.

Can someone provide the solution which steps I am missing.

Thanks,

Megha

Categories:

Error handling

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Power Platform 1919 2,205 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @MP-27111159-0,

You can refer to this documentation:

https://learn.microsoft.com/en-us/connectors/snowflakev2/

This article describes the Snowflake Connector for Microsoft Power Platform, which you can use to connect Snowflake with Power Apps and Power Automate. With this connector, you can create Dataverse Virtual Tables that expose Snowflake data and support full create/read/update/delete operations from within Power Apps or flows.

If you need more flexibility or advanced queries, you can also build a Power Automate flow that uses the Snowflake connection with Submit SQL Statement for Execution action to run custom SQL or stored procedures, then parse the results and use them in your app. This approach gives you more control over query logic than using virtual tables alone.

For Create, Update, and Delete (CUD) operations to work when using Dataverse Virtual Tables backed by Snowflake, the underlying Snowflake tables must have a primary key or a unique, non-nullable identifier. Dataverse relies on this key to uniquely identify records. Without a defined primary key or equivalent unique constraint, write operations such as insert, update, or delete will not be supported and may fail or be disabled.

1 people found this reply helpful.

Was this reply helpful? Yes No
MP-27111159-0 2 on at

Like (0)

Report
Copy link

Link copied!

hi @Power Platform 1919,

While working on Virtual Tables with Snowflake connector, initial few minutes it is showing the data in Apps After the sometime app is showing as blank.

How to restore the connectivity with snowflake Connector.

Is there any blog or documentation to achieve this.

Thanks

Was this reply helpful? Yes No
Suggested answer

Power Platform 1919 2,205 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @MP-27111159-0,

Try using Refresh(datasource). This can sometimes refresh the data and display it correctly if any issues occur.

I don’t recall having any blogs or documents for reference. In my case, I used Power Automate flows as backend data sources for my app, and Snowflake JavaScript stored procedures (SPs) as the primary datasource.

Note: When working with stored procedures, ensure that the return data type is an array rather than a variant to avoid issues with downstream processing.

CREATE OR REPLACE PROCEDURE get_data_as_json()
RETURNS ARRAY
LANGUAGE JAVASCRIPT
AS
$$
var sql = `SELECT ARRAY_AGG(OBJECT_CONSTRUCT(*)) AS result FROM MY_SCHEMA.MY_TABLE`;
var stmt = snowflake.createStatement({sqlText: sql});
var resultSet = stmt.execute();
resultSet.next();
return resultSet.getColumnValue(1);
$$;

After getting the data, I used PARSE_JSON and FORALL tin power apps to parse the JSON output. Using this approach, I effectively offloaded the logic to stored procedures and flows.

Was this reply helpful? Yes No