| 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 |
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 power bi 1с коннектор
| Method | Technology | Real-time capability | Performance | Complexity | |--------|------------|----------------------|-------------|-------------| | | 1C native HTTP service (OData 2.0/3.0/4.0) | Medium (near real-time) | Medium (paging required) | Low | | 2. Direct SQL | Direct connection to underlying DB (MS SQL, PostgreSQL) | High (live query) | High (but bypasses 1C business logic) | Medium (needs schema understanding) | | 3. Middleware API | REST API (Python/Node.js/Java) reading 1C COM or HTTP services | Medium | Variable (caching possible) | High | 2.1 OData Service (Recommended for Most Cases) 1C provides built-in publication of catalogs, documents, and registers as OData endpoints. Power BI’s OData.Feed connector can consume these. | 1C Type | Power BI Type |
| 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 | Power BI’s OData
Instead of exposing raw tables, create a 1C query that pre-joins and filters: