Forum Discussion

KEB's avatar
KEB
Icon for Helper I rankHelper I
6 years ago
Solved

Data appears in source and Power Query but not in Visual or Data view

Thank you for your help. I have never seen this happen before. I am very familiar with this report. Simply switched the source from On-prem to Cloud CRM, which has caused 0 issues doing the exact sam...
Need Help
  • KEB's avatar
    KEB
    6 years ago

    Update on this issue. A ticket has been opened and worked for the last couple of weeks. Common Data Service is not populating all of the values into PowerBI as it appears in Power Query. I can provide an update when I receive word of a resolution. My recommendation is to not use the CDS connector with Dynamics CRM.

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi , KEB 

In order to prevent data loss, please back up a new pbix file first.

Then try to  perform the following operations on the new file.

1.Transform Data -> Query Setting -> all properties -> uncheck the "enable load to report" ->  "closed&apply" 

2.Since the report is not loaded, you can’t see anything in report view.

You have to recheck the option 'enable load to report' in  “Transform Data” interface  then    "closed&apply" 

 

Best Regards,
Community Support Team _ Eason

  • KEB's avatar
    KEB
    Icon for Helper I rankHelper I
    6 years ago

    Thank you v-easonf-msft for your time. This did not resolve the problem. I had to rebuild the report connecting via XRM query, verses CDS. Not ideal but will suffice for this report.

    Thanks