Power BI Connector for Microsoft SharePoint Excel

Build 24.0.9060

Data Type Mapping

Data Type Mappings

The connector maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.

Excel Services (OData V3) Excel Services (OData V4) CData Schema
Edm.Binary Edm.Binary binary
Edm.Boolean Edm.Boolean bool
Edm.DateTime Edm.DateTimeOffset datetime
Edm.Double Edm.Double double
Edm.Guid Edm.Guid guid
Edm.Int32 Edm.Int32 int
Edm.String Edm.String string
Edm.TimeOfDay Edm.TimeOfDay time

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060