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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi There,

    I've got a similiar problem,

     

    A college has shared an excel document from their one drive for business and shared it with me. The link takes me to the sharePoint destination.

     

    The excel document has been successfully imported with a working custom function to find the addresses from lat's and long's ( 
    -22.338304000000001,30.042366999999999) | PowerBI Desktop

    I used the web connection to the excel document as per,
    https://www.youtube.com/watch?v=t4TzHu8THoA 


    This all works perfectly on the PowerBI desktop but keeps failing in the PowerBI cloud service.


    From my understanding both sources are external
    1.) SharePoint (which is the onedrive saved location)
    2.) Google API call to retieve  

    The following additional steps where test
    1.) Non Staged Query 
    Works perfectly on PowerBI desktop | Fails in the PowerBI Cloud Service

    This is the error from the PowerBI Cloud Service:
    ##[Unable to combine data] Section1/Query1/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination##

    2.) Staged Query as per https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/ 
    Works perfectly on PowerBI desktop | Fails in the PowerBI Cloud Service
    This is the error from the PowerBI Cloud Service:
    ##[Unable to combine data] Section1/Sheet1 (2)/AutoRemovedColumns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination##

    3.) Excel document was moved to sharedfolder + to "c:\PorjectFolder\data.xlsx | Both results are as follows
    Works perfectly on PowerBI desktop | Fails in the PowerBI Cloud Service
    This is the error from the PowerBI Cloud Service: Note - A Personal gateway was used and this is a NON Staged data query.

    -2147467259 Table: Sheet1.
    Underlying error message:[Unable to combine data] Section1/Sheet1/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.
    DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259


    Conclusion:

    It all works via PowerBI Deskop and fails on PowerBI cloud.

    External sources                                                                 | Failed
    Moved source to a local folder via the personal gateway | Failed