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.

Anonymous's avatar
Anonymous
Not applicable
10 months ago

I was using different sources... 

 

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