SharePoint Column Names Appear Corrupted When Importing to PBI

Hi Lydia,

It's a SharePoint problem. I need to go post this on their board and let them figure out what it's doing.  Something might have gotten corrupted when the list was being created. To explain how I got here - My URL is showing the corrupted display names for those columns rather than the ones showing in the browser when I pull up the list. My Location column is showing Field=uwbz (what I'm getting in PBI) rather than Field=Location (displaying in browser).

For everyone else...  if you experience a similar problem, to tell if it's PBI or SharePoint, look at the URL when you edit the column.

SharePoint columns have an "internal" and a "display" name. This allows you to name columns like a DBA would and then go back and add a more friendly name for your users later. For example, 'Loc' is the internal name for my 'Location' column.  In PBI, you will see the 'internal' name when you import the SharePoint list. This is true for both an on-premise or a hosted SharePoint environment. This is where you'd see 'Loc' instead of 'Location' in PBI.

Let me deconstruct the URL.

1. In O365, you have your tenant FQDN and then .sharepoint.com. In my case, it's my company name in the sharepoint.com domain.

2. Next is an OOB site collection or host-named site collection name.

3. This is followed by the Site Name.

4. /layouts/15 is where all of the core pages for the SharePoint site live on the server. In this case, it's the page to edit the field (FldEdit.aspx).

5. This is followed by the GUID for the List in curly brackets. %7B and %7D are the hex codes for curly brackets in web publishing.

6. Once SharePoint knows which list you're editing, it pulls up the field for you by its Display Name. In this case, it's 'Location.'

https://mycompany.sharepoint.com/sitecollection/sitename/_layouts/15/FldEdit.aspx?List=%7BGUIDGUID-GUID-GUID-GUID-GUIDGUIDGUID%7D&Field=Location

If Field= shows anything other than your column's display name, there's a problem in SharePoint.

For More Info 

O365 URLs and Site Addresses

https://support.office.com/en-us/article/office-365-urls-and-ip-address-ranges-8548a211-3fe7-47cb-abb1-355ea5aa88a2

SharePoint URLs for Administrators

https://www.fpweb.net/sharepoint-blog/your-sharepoint-url-list-an-administrators-guid/

W3Schools HTML URL Encoding Reference

https://www.w3schools.com/tags/ref_urlencode.asp