Snowflake Dynamic Tables Not Visible

[fgoussou]

Hello,

I am using Power BI Desktop and trying to create a model that connects to a some tables in Snowflake. These tables are "Dynamic Tables", created with the "create or replace dynamic table" command.

I noticed that when I Click on "Get Data" and use "Snowflake" as a data source, I do not see the dynamic tables in the "Navigator". I only see the normal non-dynamic tables. I am pretty sure this is not a permissions issue because both the dynamic and non-dynamic tables have the same grants.

Is there a known resolution to this issue?

[Ritaf1983 · Accepted solution]

Hi @fgoussou 

Please refer to the linked discussion:
https://stackoverflow.com/questions/75839196/can-we-import-dynamic-table-that-in-snowflake-stage-to-...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly