Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 months ago
Solved

Error when loading same table from different Snowflake accounts

I'm trying to create a Power BI report to load the same metadata table from two different Snowflake accounts. I have two Snowflake accounts, with different aliases and locators. In both Snowflake acc...
Need Help
  • Anonymous's avatar
    Anonymous
    10 months ago

    Thanks for your response. If the behavior I'm seeing is a malfunction, I haven't seen it documented anywhere. I'm assuming it must be a malfunction. I'm using the September release of Power BI Desktop. And I was able to work around the issue by using the 1.0 implementation of the Snowflake connector.

rohit1991's avatar
rohit1991
Super User
10 months ago

Hi Anonymous 

It looks like both queries still have the same navigation steps and final query names (DIM1_COUNTRY), so Power BI treats them as the same object. Even if accounts are different, the query folding step causes duplication.

 

Try these fixes:

1. In Advanced Editor, rename each query with a unique step name:

e.g., DIM1_COUNTRY_ACC1 and DIM1_COUNTRY_ACC2.

 

2. Make sure the Source step explicitly includes the full account URL + DB + Schema.
Example:

Source1 = Snowflake.Databases("account1.snowflakecomputing.com"),
DB1 = Source1{[Name="DB1",Kind="Database"]}[Data],
Table_ACC1 = DB1{[Name="DIM1_COUNTRY",Kind="Table"]}[Data],
Source2 = Snowflake.Databases("account2.snowflakecomputing.com"),
DB2 = Source2{[Name="DB2",Kind="Database"]}[Data],
Table_ACC2 = DB2{[Name="DIM1_COUNTRY",Kind="Table"]}[Data]

 

3. Load them with different names into the model so they don’t overwrite each other.

 

This way, Power BI keeps them as separate queries and won’t mix up the data.

Anonymous's avatar
Anonymous
Not applicable
10 months ago

I tried with this 👇and it didn't work