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

[KEB]

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 same thing on 15 other PBix.  All of the data is correct and visible in Power Query, but when viewing in a visual or in the data view entire column values are gone. Header is present though.

I have no filters and no relationships that would limit the results. Data types have been triple checked. Again thank you for your help.

[KEB · Accepted solution]

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]

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]

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