Forum Discussion
SharePoint Number % Column
If I import a SharePoint list via this Implementation 2.0 method:
SharePoint.Tables("url_here", [Implementation="2.0", ViewMode="All"])
a number column shown as percentages is coming in as null. It contains no values when it clearly does on SharePoint. If I change the method to this:
SharePoint.Tables("url_here", [ApiVersion=15])
the column will come in fine, but then I have to deal with column real names instead of display names and have a big problem with time zones. Is this a known issue?
2 Replies
JSpradlin , check if any step added in the power query that has an error or done some data type change which has caused it
debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s
refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTsI'm viewing the table from the initial navigation step. Shown as a percentage on SharePoint yields null values. Shown without formatting shows the desired decimals.
As percentage, you can see it's brought in as a decimal formatted column.
As a normal number column:
