Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Odd Mashup Error - Refreshes Failing

We have refreshes failing on multiple data sources despite the gateway being online and credentials cross checking. Table fields have not changed, just on a republished version after credentialling was changed, but all updated. Any thoughts:

  • 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":"Information is needed in order to combine data"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SQL\",\"path\":\"tas2;kern\"},{\"kind\":\"PowerBI\",\"path\":\"PowerBI\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: ORDERS.
  • Cluster URIWABI-US-WEST2-redirect.analysis.windows.net
  • Activity ID00000000-0000-0000-0000-000000000000
  • Request IDd81a501f-b6dc-41fb-a1d1-becdc72702ee
  • Time2022-08-22 17:11:35Z
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous , One of our users had the same issue recently. Resolved it by setting the Privacy Level for all the data sources.

     

    Data soure Settings > Edit Permissions > Set the Privacy Level

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous , One of our users had the same issue recently. Resolved it by setting the Privacy Level for all the data sources.

     

    Data soure Settings > Edit Permissions > Set the Privacy Level

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you will try this now!

  • Set the privacy level to what?  There are 4 settings.