Import data from Snowflake views

[JohnS4444]

Hi,

i would like to import data from several Snowflake views.

After setting up the connection i can only see tables listed in the data navigator on the left side and no views.

When i use a SELECT * sql statement for the view it works ...

This cant really be an issue of missing GRANTs on Snowflake side.

I checked the user/role with other db clients and there i can list views in a schema without problems.

Can anybody give me some advise?

Thanks a lot.

[JohnS4444]

Thanks a lot for the insight.

I deactivated the Snowflake connector preview features but when i create another data connection after i get the attached certificate error. Refreshing the data structures already imported is no problem though.

Is there anything else i have to do here?

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[lbendlin · Accepted solution]

known issue with the "new" Snowflake connector. Revert back to the old/legacy connector while this is (hopefully) being fixed.