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 ...
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
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: