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?
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:
Helpful resources
Power BI Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
