Local Gateway - Active Directory and SharePoint - Update Error, what to do?

[TommyMossberg]

I have a report with SharePoint sources and a ActiveDirectory connection where the update works perfectly fine on Power BI Desktop. But on the Service I get random/diffrent MashupData-error every other time. Last time it was like this....

I checked the access and the same user have access to the Active Directory, the SharePoint and the Local gateway so I don't understand why there is a (x) infront off the SharePoint connection like shown below. 

When I have a report with only the SharePoint connection or only the AD via the local gateway it seams to work fine. 

What to do? Where to start? 

Thanks in advance!
//Tommy

[ibarrau]

Hi. I usually recommend to review the Desktop file and run a full refresh. Mashap errors are usually threw in the desktop too. In this case before doing that I will ask, is that sharepoint onpremise or is it online?

If you have sharepoint online and other sources on premise, it is recommended to turn the following option in the Gateway Settings in order to help it flow correctoy. Letting onpremise for gateway and cloud directly.

If sharepoint is cloud, that option will help. You only need to go under dataset settings or schedule refresh and Edit Credentials under the Data Source Credentials.

I hope that helps,

[TommyMossberg · Accepted solution]

The checkbox is checked and I have come to the conclusion that the most frequent error is "We cannot convert the value "[Binary]" to type Binary." 

So I'm retracing my steps to a point where I don't get that error.