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 ...
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 

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.