Forum Discussion
Solved
Published Report/Dataset with No Data
Hello! This is a first for me. I have published many reports with no issues previously. I have a report built in desktop that is fully funtional. It is direct query of a SQL Database. The only t...
We found our problem. It had to do with the data source, CRM. Long story short, to view the data, the viewer had to be a user in the CRM system. I am a user which is why I could see the data in Desktop, but the Service pings as a separate user which was not setup as a user in CRM. Adding the Service user to CRM solved the issue as a band-aid. Will be looking at ways to improve how that data is queried so that is not a requirement.
Hi,
What happens when you refresh the dataset from the service? Are you getting errors?
No errors. Just no data is ever in the dataset.