Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

There was an error when processing the data in the dataset

Hi Team, Hope you are doing well. I am facing an issue while refreshing my report on PB Service. I have two data source(One from SAP HANA and Other is from Sharepoint Folder) .My report is getting ...
General Comment
Need Help
Show and Tell
ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
3 years ago

Hi. Are you using a Gateway? can you share how are you connecting to sharepoint?

If you are using a gateway and a cloud source, you need to specify that to the gateway in order to let you add the new source to gateway and edit credentials for the cloud source and make it work. The setting is at the manage gateways when checking the specific gateway.

The error can also be a wrong connection to sharepoint. I would recommend this way: https://blog.ladataweb.com.ar/post/185337134590/alternativa-para-conectar-power-bi-a-onedrive

I hope that helps,

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    We are using what ever your provided but still facing the issue when refresh report in service and same report is working fine in desktop .We have also tested refresh working fine till merging the share point file cloumns with SAP view only problem after mering refresh in service not working ..

    once againg mentioning refresh is not happening in service but working fine in desktop.

    in service only working fine till merging the columns from differnt source.

    • ibarrau's avatar
      ibarrau
      Icon for Super User rankSuper User
      3 years ago

      Ok. If this was working with those two exact sources and you added just a merge, make sure both credentials for sources have the exact same privacy level. Merging will only work with the same privacy level, I would recommend organizational. The refreshes at service doesn't work the same ask desktop, that's why it usually doesn't match 😞

      I hope that helps,

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi ibarrau ,

        We checked both of the data source settings are same "Organisation" level and still its giving me the same error .

        Is there anything you can suggest .?

        I am trying to update my gateway version and will see it will work or not.

         

        Thanks,

        Ashish