Power Bi 1с Коннектор !!exclusive!! May 2026

1C’s Date includes timezone-less datetime. Use DateTimeZone.RemoveZone() in Power Query. 5. Performance Optimization 5.1 Query Folding OData supports partial folding: filters on indexed fields are pushed down. Example: Table.SelectRows(Source, each [Deleted] = false) becomes $filter=Deleted eq false .

let Source = OData.Feed( "http://1c-server/1c/odata/standard/odata/Catalog_Products", null, [Implementation="2.0", Timeout=#duration(0,10,0,0)] ), #"Expanded Properties" = Table.ExpandRecordColumn(Source, "MainProperties", ...) in #"Expanded Properties" 1C returns data in chunks. Use NextLink handling – Power Query automatically manages this with [Implementation="2.0"] . For better performance, add $top=5000 and iterate. 3.4 Authentication Supported methods: Basic, Windows (NTLM/Kerberos), Anonymous. For Power BI Service, use On-premises data gateway with Windows authentication. 4. Data Type Mapping 1C data types and their Power BI equivalents: power bi 1с коннектор

| 1C Type | Power BI Type | Notes | |---------|---------------|-------| | String | Text | | | Number (decimal) | Decimal | Watch for scale (max 28 digits) | | Number (integer) | Whole number | | | Date | Date/Time | | | Boolean | True/False | | | UUID (GUID) | Text | Convert to string | | Link (ref to object) | Text or Record | Expand to key field | | Tabular section | Table (nested) | Unpivot or expand | 1C’s Date includes timezone-less datetime

| Name | Method | Price | Key Feature | |------|--------|-------|-------------| | | OData + caching | Commercial | Automatic schema discovery | | Power BI Connector by DevExpress | Direct SQL | Commercial | Supports 1C query language | | OData 1C Free (GitHub) | OData wrapper | Open source | Fixes paging limitations | Performance Optimization 5

Instead of exposing raw tables, create a 1C query that pre-joins and filters:

let BaseUrl = "http://1c-server/odata/standard/odata/Catalog_Products", GetPage = (url) => let Response = OData.Feed(url, null, [Implementation="2.0"]), NextLink = if Record.HasFields(Response, "odata.nextLink") then Response[odata.nextLink] else null in Response, AllPages = List.Generate( () => [Page = GetPage(BaseUrl), Next = null], each [Page] <> null, each [Page = GetPage([Next]), Next = null], each [Page] ), Combined = Table.Combine(AllPages) in Combined