There was an error when processing the data in the dataset

[Anonymous]

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 refreshed  on desktop however when i am trying to refresh my report on Serivce I am getting below mentioned error . 

Is there any one who can suggest what needs to be done here. My credentials are validated and everything is working fine.

@Ashish_Mathur  -Please suggest anything 

Thanks in Advance !

Ashish

[Bhaskarkolli9]

Please any one come faced this kind of issue let us know.

[ibarrau]

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,

[Bhaskarkolli9]

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]

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]

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

[ibarrau]

It can be related with gateway. If updating the gateway doesn't work, go with this. I have read the following some time ago at the forum.

Check transport layer security (TLS) 1.0 and 1.1 for Power BI. Upgrade the TLS version of your Power BI application to TLS 1.2 before then. 

Solution: Adding followung code  

System.Net.ServicePointManager .SecurityProtocol = SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12; 

Follow below post suggested by microsoft support team:

https://azure.microsoft.com/en-in/updates/power-bi-support-for-transportlayer-security/

I hope that helps,

[Anonymous]

Hi @ibarrau ,

Thank you for your quick response. I have updated my gateway but still i am facing the same issue.

and  I have check .netframework version its also upto date.

Is there any option where we can raise  a ticket to Microsoft?

Thanks,

Ashish