Snowflake dataset refresh not working with the April 2022 desktop version of Power BI

[DaadkrachtNL]

Hi,

When refreshing a dataset locally in Power BI version april 2022, I am getting a bunch of errors about 'cyclical references' for each table.

I am using Snowflake as a datasource, with Dual - formatted tables.

It fails for each dataset.

For me, the current solution is to downgrade to the march 2022 version. This is a direct solution to the issue.

I hope for a solution to this in the May version!

[v-cazheng-msft]

Hi @DaadkrachtNL,

I’ll keep an eye on this issue. Once the version of May is published, I’ll inform you from here and hope you a try at that time. And currently, please use older version of Desktop as workaround. Thanks for your understanding!

Best Regards,

Community Support Team _ Caiyun

[DaadkrachtNL]

Unfortunately, the issue still occurs in the May 2022 version.

[mail2inba4]

@v-cazheng-msft Is the problem resolved? If so, could you kindly tell us which version that is?

[DaadkrachtNL]

I found a solution by accident.

In the advanced editor, I was customly doing this: 

"

let
Bron = Snowflake.Databases("MYSERV","POWEBI"),
Database = Bron{[Name="X",Kind="Database"]}[Data],
Schema = Database{[Name="Y",Kind="Schema"]}[Data],
Table = Schema{[Name="Z",Kind="Table"]}[Data]
in
Table

"

It seems that 'Schema' became a reserved term in Power BI desktop versions since April 2022, hence resulting in a crash.

I renamed 'Schema' in the advanced editor, which solves the issue.