Forum Discussion

effertz12's avatar
effertz12
Helper II
4 months ago
Solved

Privacy Levels and Static Enter data tables

Obviously theres no "ignore privacy levels" option in service. I am using a local sql server table in my semantic model to filter down data i am getting from snowflake. Even when setting the privacy levels to the same level i get errors refreshing it in Service. Is the only way to be able to use this table from SqlServer just creating a static table in my model that ill have to update manually? Cant seem to find any other solution. 

Need Help
  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    4 months ago

    Hi effertz12 ,

     

    To avoid cross-source mashups in Power BI Service. Stage your SQL filter table into Snowflake (or replicate Snowflake metadata into SQL) so all joins happen inside one source, then connect Power BI only to that unified source. If staging isn't possible, use a Power BI Dataflow to load each source separately and combine them there before loading into your dataset. As a last fallback, keep a static table in the model.

     

    Thanks,

    Sai Teja 

6 Replies

    • effertz12's avatar
      effertz12
      Helper II
      4 months ago

      Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"[Unable to combine data] Section1/FACT__COMPANY_INVENTORY/Changed Type references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Snowflake\",\"path\":\"d*****.privatelink.snowflakecomputing.com;A***********L\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacyError"}}],"exceptionCulprit":1}}}

  • TomMartens's avatar
    TomMartens
    Super User
    4 months ago

    Hey  effertz12 ,
    Given the error message, you need to create a custom function in Power Query and invoke it in the Snowflake query to filter the data. 

    The below M script showcases this for two SQL Server databases; in your case, replace the transactions datasource with your Snowflake connection:

    // Alternative: join-based filtering (often faster, more foldable)
let
    fnGetActiveCustomers = () =>
        let
            Source = Sql.Database("server1.database.windows.net", "SalesDB"),
            Result = Source{[Schema="dbo", Item="ActiveCustomers"]}[Data],
            KeysOnly = Table.SelectColumns(Result, {"CustomerID"})
        in
            KeysOnly,

    ActiveCustomers = fnGetActiveCustomers(),

    Transactions = Sql.Database("server2.database.windows.net", "TransactionsDB")
        {[Schema="dbo", Item="Transactions"]}[Data],

    // Inner join keeps only matching rows — same effect as filtering
    Filtered = Table.NestedJoin(
        Transactions, {"CustomerID"},
        ActiveCustomers, {"CustomerID"},
        "Match", JoinKind.Inner
    ),

    // Drop the join artifact column
    Result = Table.RemoveColumns(Filtered, {"Match"})
in
    Result

     
    Hopefully, this helps to tackle your challenge.

    Regards,
    Tom

    • v-kpoloju-msft's avatar
      v-kpoloju-msft
      Community Support
      4 months ago

      Hi effertz12, 

      Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to TomMartens,  for those inputs on this thread.

      Has your issue been resolved? If the response provided by the community member TomMartens,  addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

      Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

      Thank you for using the Microsoft Community Forum.

      • v-kpoloju-msft's avatar
        v-kpoloju-msft
        Community Support
        4 months ago

        Hi effertz12, 

        Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

        Thank you.

  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    Super User
    4 months ago

    Hi effertz12 ,

     

    To avoid cross-source mashups in Power BI Service. Stage your SQL filter table into Snowflake (or replicate Snowflake metadata into SQL) so all joins happen inside one source, then connect Power BI only to that unified source. If staging isn't possible, use a Power BI Dataflow to load each source separately and combine them there before loading into your dataset. As a last fallback, keep a static table in the model.

     

    Thanks,

    Sai Teja