Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Fabric community is now in read-only for platform upgrade. Learn more

SQL Server smallint data get converted to numeric in Power Query

Submitted by Anonymous on ‎10-13-2022 07:20 AM

Here's a thread on Community establishing the the fact that values typed as smallint in SQL Server are convereted to numeric in Power Query.  Utilizing "Detect Data Type" will change it to Whole Number, but that breaks the query folding.  Don't know why it just can't get it right the first time.

Status: Needs Info
See more ideas labeled with:
4 Comments (4 New)
Comments
Anonymous
Not applicable
‎10-13-2022 11:02 PM

Hi @Anonymous ,

 

Sorry, what's your problem? What do you want to know?

 

Best regards,

Community Support Team Selina zhu

Anonymous
Not applicable
‎10-14-2022 07:07 AM

Why does Power Query change a data typed as smallint in SQL Server to numeric instead of whole number.

Anonymous
Not applicable
‎10-17-2022 12:39 AM

Hi @Anonymous ,

 

This document has a description of data types in power query, hope it can help you.

Data types in Power Query - Power Query | Microsoft Learn

 

Best regards,

Community Support Team Selina zhu

HenrikJeppsson
Frequent Visitor
‎03-06-2025 07:47 AM
It looks likes this has not been adressed. I try to help by explaining what the Original Poster is refering to. When you to an M-query like the one below Columns of various types os SQL servere ingegers are wrongly mapped. SQL Server - M [Int]->Int64.Type Correct [Smallint]->Number.type WRONG same error goes for [TinyInt], [Bigint] seems fine. let a = Sql.Database("dwh.REDACTED.int", "dwh"), b = a{[Schema="pbi2",Item="f_FinanceGL_InclBudget"]}[Data] in b
Idea Statuses