Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 thing different for this one vs the others I have done previously is that it is different source data (usually pull from GP, this is pulling from CRM). When I publish the report to Service, all of the visuals are visible but the values are blank. It is like the dataset has no data. I have tried every reboot and refresh imaginable.
Any ideas? Thanks in advance!
Solved! Go to Solution.
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.
Here is what it says under credentials and I am using a gateway. We have checked and double checked that I have access to the database on the server.
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.
Are you using On-Prem CRM or Dynamics cloud?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.