Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DM_GWPipeline_Gateway_MashupDataAccessError

Hello everyone,   I saw all the bugs like this one but didn't find a way to solve it yet.   In Power BI Desktop it refresh ok. Each time that I publish again in PBI online, it fails and the table...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Solved!

    Changing the Privacy Level in Power BI online as solved the refresh issue.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you for your help.

Most of the suggestions I already tryed before and it didn't work.
I try more things that was in this article but still same error.

KoketsoM's avatar
KoketsoM
Frequent Visitor
3 years ago

Checking how you eventually resolved this

  • PedroJunqueira's avatar
    PedroJunqueira
    Frequent Visitor
    2 years ago

    Hi KoketsoM 

     

    Same issue here. I tried different privace levels and nothing so far. 

    Would be curious if this is resolved or someone resolved the issue.

     

    I am using the Oracle Autonomous Database (Cloud based)

     

    Could connect with PBI desktop. Configured Gateway as instructions.

     

    I used the same gateway to other sources (SQL on prem) and all working fine. Just Oracle I am having those issues.

     

    Regards

     

    • shaunwilks's avatar
      shaunwilks
      Helper V
      2 years ago

      Having the same issue at our end And its not resolved nor should MS Ignore it.

       

      Changed the Privacy Levels as suggested and it worked twice, then reverted back to the error again.  Whether using the Refresh Now or Scheduled Refresh. Issue continues.

      Report updates without issue inside the PBI desktop.

       

      My query tries to combine a query of the contents of two XML files.

      Its a pretty basic read of plain text.

       

      I should also add - Why should Privacy Levels mean anything anyway when the report has the following Privacy Setting...

       

       

       

      {"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

  • catcher21's avatar
    catcher21
    New Member
    1 year ago

    Same issue, my solution was to set refresh schedule with multiple 'dummy' refresh times that almost always fail but for whatever reason it allows my necessary refreshes succeed. Not a viable business solution when only allowed a limited number of refresh instances.