Primavera P6 to Power BI Text

[tbarnes1985]

Good morning,

My company has invested in the ability to tranform P6 data to automatically generate data into Power BI to allow us to create live reports.  One facet we have been using is inserting notes to P6 activities within a schedule that generate into the Power BI dashboard.  One issue we consistently have is that the text pulls in with "weird" characters.  The text shows us as   or some other form of the same nature.  We have tried to remove "Enter" spaces within the notes, as well as double spaces between periods and the next sentence and using only one period.  Any insight would be greatly appreciated.  Thank you for your time!

Regards,

TB

[v-chuncz-msft]

@tbarnes1985 

To deal with non-breaking space, you may try Replace values in Query Editor.