Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data source error - DM_GWPipeline_Gateway_MashupDataAccessError

We are trying to refreshing this report through Gateway connected to MS Access, and got the below error message.  Does anyone encounter similar issue and resolved it?  Please advise. -------- Data ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

My gateway is online and I am able to refresh on Power BI desktop.

My data sources are MS exchange and SQL Server. Scheduled refresh and on demand refresh fails with this 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/exchange_connect/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. 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\":\"Exchange\",\"path\":\"[email protected]\"},{\"kind\":\"SQL\",\"path\":\"server.database\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacyError"}}],"exceptionCulprit":1}}} Table: exchange_connect.

 

Any help would be greatly appreciated.

carlogazzani's avatar
carlogazzani
Regular Visitor
1 year ago

I am facing same error...

My model has XLSX and SQL queries merged in 1 table. This merge is causing the problem. If i refresh tables separately , it works fine.

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    carlogazzani better to open a new thread.

     

    Avoid merges, use the data model instead.

    • khaeshr46's avatar
      khaeshr46
      Frequent Visitor
      1 year ago

      Can you explain this more? Im having the same issues. I have a Dataverse table that I am importing and merging which is causing the issue. Without the merge, the Dataverse table is refreshing just fine.

       

      What do you mean by "use the data mode"?

       

      Are you suggesting importing both the tables seperately, using UNION to merge them in PBI instead of PQ?

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

        In the semantic model you can visually join tables via relationships. This will be running in memory so it will be a lot faster.