Forum Discussion
Dataset Refresh failing without any error message
Hi
I have published a report to the service and it has been successfully refreshing for long time.
It reads from multiple source (Sharepoint, Oracle, APIs, dataflows) and uses an on-premise gateway.
I have finished developing a newer version of the same report with more features.
Refreshing the new version on the Desktop (Feb 2021 release) is successful, but once I publish the new version to the service, refreshes are always failing, and the problem is that the error message is completely empty.
Can you please advise on what could be the reason and how to troubleshoot?
Best Regards,
Karim
aj1973 , I didn't get to upgrade the gateway since I have less control over it.
But I eventually thought about another possible reason and I was right.
I had the privacy settings set to "ignore privacy levels". As we know, this helps on the Desktop and causes issues in the service.
Checking the gateway logs confirmed this direction.
I disabled this ignore setting and did some changes to the queries to resolve the Formula.Firewall errors.
Now the dataset is refreshing correctly.
Thank you for your support and care 👍
P.S. I still don't like the fact that the service doesn't give any indication on the error.
