SharePoint Number % Column

[JSpradlin]

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?

 

[amitchandak]

@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-Lag0VOiTs

[JSpradlin]

I'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: