The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to 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
@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
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
@Anonymous , refer if this can help
Thanks,
but in my case i try to get data from an excel sheet located at a sharepoint not a sharepoint list.
Regards
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
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
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