Data flow populating some - but not all columns in desktop
I have come across a strange situation where I've created a new dataflow (Drawing data from a Dynamics entity). After doing the transformations in Power Query, I saved the dataflow and refreshed it in the service.
I then loaded the dataflow in desktop - and all lines of the dataset have loaded - But some columns are completely blank - but yet there is definitely data in the column in question (confirmed when looking at it in power query) - but the same column is blank when opening in desktop?
Any why only some fields? Seems strange that it loads nearly all other columns with all data in the dataset - but some columns are blank??
Any guidance on where to start troubleshooting would be appreciated.