Power Bi 1с | Коннектор

OData connector with incremental refresh.

SELECT Sales.Ref AS SaleID, Sales.Date, Products.Name AS ProductName, Sales.Quantity FROM Document.Sales AS Sales LEFT JOIN Catalog.Products AS Products ON Sales.Product = Products.Ref WHERE Sales.Date >= DATETIME(2024,1,1) Publish this as an OData data source. power bi 1с коннектор

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 OData connector with incremental refresh

Instead of exposing raw tables, create a 1C query that pre-joins and filters: Products.Name AS ProductName

| 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 |