Forum Discussion
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.'
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
SharePoint URLs for Administrators
https://www.fpweb.net/sharepoint-blog/your-sharepoint-url-list-an-administrators-guid/
W3Schools HTML URL Encoding Reference
llhanley,
I am unable to reproduce your issue, please connect to the specific online list using OData feed entry in Power BI Desktop and check if the issue still persists. You can use the OData URL: https://yoursharepointsite/_vti_bin/listdata.svc/ListName.
Regards,
Lydia
Hi Lydia,
It appears that my company has access via OData blocked.
Sorry...
Regards,
Lori
I re-created the list and that one imports fine. The other is still showing the weird 4 character 'random' column names. Same ones as before, but not the actual column names. I had a coworker try to connect and she got the same result with that particular list. Other lists in the site are fine. I don't get it.
llhanley,
Does this list contain special columns? How about you use Power BI Desktop May release?
Regards,
LydiaHi 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.'
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
SharePoint URLs for Administrators
https://www.fpweb.net/sharepoint-blog/your-sharepoint-url-list-an-administrators-guid/
W3Schools HTML URL Encoding Reference