After many technical struggles with Azure portal for Entra ID authentication, yesterday only I have fixed the snowflake connector issue with PowerApps, and snowflake connector got established.
After the connection I am trying to add data from snowflake data warehouse VIEW/TABLE.
but I am getting below error when trying to fetch the data from Snowflake.
I am not sure how to fix this? Is there any pre-requisites needs to be done before this step?
For transparency, the below is from a couple of searches as I do not use Snowflake - I hope it is helpful to you
Possible cause
Role visibility issue
In Snowflake, just because a user has access to a table doesn’t mean they can see it in Power Apps unless the role used for authentication has explicit USAGE and SELECT grants.
Power Apps connects as the Entra ID user, but Snowflake maps that to a role (either default role, or the one specified). If the role doesn’t have the grants → “resource not found”.
Case sensitivity / naming mismatch
Snowflake treats unquoted names (MYTABLE) as UPPERCASE.
If your object is created with quotes, like: CREATE TABLE "MyTable"
then it becomes case-sensitive, and Power Apps may fail to find it unless you reference "MyTable".
Power Apps usually queries in uppercase → mismatch = resource not found.
Wrong database/schema context
If the connector is pointed at a database, but your table is in a different schema or database, Power Apps won’t find it.
Example: if your table is in MY_DB.SALES.CUSTOMERS, but the connector defaults to MY_DB.PUBLIC, it won’t resolve.
Possible fix
Run the following in Snowflake as an account admin (replace with your names/roles):
-- Give access to the database & schema GRANT USAGE ON DATABASE MY_DB TO ROLE <your_powerapps_role>; GRANT USAGE ON SCHEMA MY_DB.SALES TO ROLE <your_powerapps_role>;
-- Give access to the table or view GRANT SELECT ON TABLE MY_DB.SALES.CUSTOMERS TO ROLE <your_powerapps_role>;
If it’s a view, also grant SELECT on all underlying tables to the same role.
Then, in Power Apps:
Reconnect to the Snowflake connector.
Try browsing again for the table/view.
Debugging
In Snowflake Worksheets (logged in as the same Entra ID user/role), run:
SHOW TABLES IN SCHEMA MY_DB.SALES;
If the table/view does not appear → permissions/role problem.
If it does appear there, but still fails in Power Apps → likely case sensitivity or unsupported datatype.
Please ✅Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful?
Visit my blog Practical Power AppsLinkedIn
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
51
Share
Report
All responses (
Answers (
