Combine Data appends _x000D_ in column

[Anonymous]

Hi,

how can i prevent that  _x000D_ will be appended to a column name when i combine a single file(xlsx) from a sharepoint folder?

Regards

Holger

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous]

Hi,

i opened as source a sharepoint folder. Then i choose a single file and combined it.

After import into transform window, one column name changed to _x000D_coloumnName_x000D_ instead of using column name.

a ilaso have some records which have _x000D_ inserted. Why does it happen and how can i prevent it?

Thanks

[amitchandak]

@Anonymous , refer if this can help

https://community.powerbi.com/t5/Desktop/How-to-retrieve-quot-correct-quot-column-names-from-SharePoint/td-p/484431

https://social.technet.microsoft.com/wiki/contents/articles/40040.power-bi-two-way-to-get-data-from-sharepoint-list-library.aspx

[Anonymous]

Thanks,

but in my case i try to get data from an excel sheet located at a sharepoint not a sharepoint list.

Regards

[Anonymous]

Hi @Anonymous,

If you only get singe file from SharePoint/one drive, you can refer to the following document to use excel connector to get cloudy data: Use OneDrive for Business links in Power BI Desktop 

After getting data to power bi, you can modify the 'change type' step to change the column names recognized incorrectly.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi,

in that way i would not be able to connect with my org account.

Thats why im using sharepoint folder->select a single file->combine. This worked with the org account, but it appends _X000D_ in some column headers or Record Values. I Think this happens when there are some specail Characters in it(like ( ,),# ).

Regards

Holger

[Anonymous · Accepted solution]

HI @Anonymous ,

>>This worked with the org account, but it appends _X000D_ in some column headers or Record Values. I Think this happens when there are some specail Characters in it(like ( ,),# ).

Yes, that may be a causing of these specific name appears on your table. Maybe You can try to modify your file origin type and formats to confirm if they fixed the issue.

Two methods to display special characters on Power BI dashboards 

Regards,

Xiaoxin Sheng