Forum Discussion

RGI's avatar
RGI
Helper III
7 years ago

Something went wrong ... ReasonPrivacyError

I'm getting this error when trying to refresh a dataset   Something went wrong Cannot connect to the mashup data source. See error details for more information. Please try again later or contact ...
Need Help
RGI's avatar
RGI
Helper III
7 years ago

Setting the privacy to none made no difference.

Any other suggestions?

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi RGI,

 

Can you share the Power Query code in the Query Editor? 

What are the data sources?

The IDs are too old. I only find that it kept saying Personal gateway isn't available. 

 

Best Regards,
Dale

  • RGI's avatar
    RGI
    Helper III
    7 years ago

    This is the latest error message:

     

    Something went wrong
    Cannot connect to the mashup data source. See error details for more information.
    Please try again later or contact support. If you contact support, please provide these details.
    Underlying error code-2147467259 Table: Departments.
    Underlying error message[Unable to combine data] Section1/Departments/AutoRemovedColumns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
    DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
    Microsoft.Data.Mashup.MashupSecurityException.DataSources[{"kind":"Teradata","path":"Db"}]
    Microsoft.Data.Mashup.MashupSecurityException.ReasonPrivacyError
    Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
    Activity IDb5961221-9cf8-4c92-a6e6-a8146d507d2d
    Request ID88694e27-61d5-1016-8aef-febcecdf8b12
    Time2018-11-19 17:09:24Z

     

    There are many querys - and it seems to fail randomly in different places.

     

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi RGI,

       

      Did you add any columns in the Query Editor, which query other data sources? 

      I would suggest you troubleshoot it by deleting the combined queries first. 

      I didn't find anything useful in the log. 

       

       

      Best Regards,
      Dale

      • RGI's avatar
        RGI
        Helper III
        7 years ago

        I'll have to wade through the code to understand it ... not my own. I normally use an abstract layer in a database and for production report prefer to bring spreadsheets into the database.