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.
Hi All
I have a field in the desktop model. It counts the number of Completed phone call activities that have left a voice mail, sucked directly out of MS Dymanics CRM 2015
2 hours later the power data in the report refreshes as per the schedule.
And the data for that one field disappears.
Everything else is fine. Lots of other data fields successfull there.
But not this one.
Any ideas?
Brett
@brettlloydpayne in power bi service under Datasets go to your dataset and drop that field into a table visual and see if it returns anything. If not I would suggest you check data source and confirm it does have value.
Hi
As mentioned in my post, it is showing data in the visual, which incidently, is a table.
So its disapppearing! Thanks for trying. Any other thoughts?
Any new views on this item please?
Thanks
Brett
Incidently, we seem to have fixed this with the help of MS Professional Services support.
There looks to have been two issues.
1) After the first data refresh, the background schema of the model was defaulting to the out of the box schema.
2) When a field in MSD was a multiple option field and that field text was Yes or No, even as text, Power BI prefered to set those data types as TRUE/FALSE even though that was not the field setting in MSD.
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.