Forum Discussion
Table NotFound Error for Snowflake Views
The intermittent "Table Not Found" error when accessing Snowflake views in Power BI is usually caused by the active role not having proper access or not being set during the session. To resolve this, ensure the correct role is set as active using USE ROLE your_role; in Power BI's advanced options. Also, grant SELECT privileges on all underlying tables or views used within the Snowflake view to that role. Clear Power BI's cache from File > Options and settings > Options > Data Load > Clear Cache, and make sure object names are consistently cased to avoid case-sensitivity issues.
The intermittent "Table Not Found" error when accessing Snowflake views in Power BI is usually caused by the active role not having proper access or not being set during the session. To resolve this, ensure the correct role is set as active using USE ROLE your_role; in Power BI's advanced options. Also, grant SELECT privileges on all underlying tables or views used within the Snowflake view to that role. Clear Power BI's cache from File > Options and settings > Options > Data Load > Clear Cache, and make sure object names are consistently cased to avoid case-sensitivity issues.
Thank you. Clearing Power BI Cache seems to solve the problem!