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 ,

 

please provide the error message(s).

Regards,
Tom

  • 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}}}