Forum Discussion
jonoling
5 years agoFrequent Visitor
SQL Tables importing without associated data types
Hi, I have a fact table that I'm connecting to in SQL. When reviewing the INFORMATION_SCHEMA.COLUMNS query in SSMS for the table it shows the [order_date] field as being stored as a datetime data...
- 5 years ago
None, it's the out of the box SQL Server connector from Power Query. The only inputs it's taking is the SQL string and DB, then navigating to the table in question.
let
Source = Sql.Database(sqlserver, db)
Table = Source{[Schema="dbo",Item=tablename]}[Data]
in
TableAgree, it doesn't seem to be a widespread issue, this is the first time I've come across an issue like this. Just tested with a sandbox WorldWideImporters DB and the native query generated brings through datatypes fine.
Odd!
lbendlin
Super User
5 years agoAnything suspicious on the Fiddler or Power Query Diagnostics?