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)

In Power Query Editor:

This paper defines a repeatable architecture for connecting Power BI to 1C, evaluates performance trade-offs, and provides guidelines for secure, maintainable ETL processes.

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"

The challenge? Connecting these two distinct worlds isn't always as straightforward as clicking "Get Data."

Heavy Power BI queries can put a significant load on the 1C server process (ragent/ rmngr). If possible, use a dedicated SQL database (Data Warehouse) as a middle layer:

Power Bi 1с — Коннектор _hot_

In Power Query Editor:

This paper defines a repeatable architecture for connecting Power BI to 1C, evaluates performance trade-offs, and provides guidelines for secure, maintainable ETL processes.

The challenge? Connecting these two distinct worlds isn't always as straightforward as clicking "Get Data."

Heavy Power BI queries can put a significant load on the 1C server process (ragent/ rmngr). If possible, use a dedicated SQL database (Data Warehouse) as a middle layer: