Forum Discussion

saranicole2695's avatar
saranicole2695
Frequent Visitor
6 years ago
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...
Need Help
  • saranicole2695's avatar
    saranicole2695
    6 years ago

    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.

saranicole2695's avatar
saranicole2695
Frequent Visitor
6 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Are you using On-Prem CRM or Dynamics cloud?