Read FAQ
NEW
Bitrix24 Support
Registration and Authentication
How to start
My Profile
Feed
Messenger
Start page: the Vibe
Calendar
Bitrix24 Drive
Bitrix24 Mail
Workgroups
CoPilot - AI in Bitrix24
Tasks and Projects
CRM
Contact Center
Sales Center
CRM Analytics (beta)
BI Builder
Sales Intelligence
Inventory Management
Marketing
Sites
Online Store (beta)
CRM + Online Store
CRM Store (beta)
e-Signature
e-Signature for HR
Company
Knowledge base (beta)
Automation
Workflows
Telephony
Market
Subscription
Settings
Enterprise
Desktop App
General questions
Bitrix24 On-Premise
Log In
Your Bitrix24
Authorize to enter
your company's Bitrix24.
Enter

Bitrix24Care

Limit the number of columns in Microsoft Power BI entity

In Power BI you can configure a query and reduce the number of uploaded columns of any BI entity. For example, you use data from deal custom fields for a report, but you have a lot of columns to upload and not all of them are needed.

Select the desired columns and limit their number, so you speed up data loading and simplify processing within Power BI.


How to limit the number of columns

First, let's open the Transform data section and see what data is currently uploaded and what data is needed for the report.

When you have selected the desired columns, copy their names and open them in the advanced editor bx24_load_entity.

Add a command with your fields to the editor.

 fields = { [name = "DEAL_ID"], [name = "DATE_CREATE"], [name = "UF_CRM_1645431691305"] } 

In our example, we use the following fields:

  • DEAL_ID – deal identifier
  • DATE_CREATE – deal creation time
  • UF_CRM_1645431691305 – unique user field

You can read more information about the meaning of the fields in the article: Description of entity fields in BI Analytics.

After that, only certain columns will appear in the entity and the data will be loaded faster.


Was this information helpful?
Integration specialist assistance
That's not what I'm looking for
Complicated and incomprehensible text
The information is outdated
It's too short. I need more information
I don't like the way this tool works
Go to Bitrix24
Don't have an account? Create for free
Related articles
Transfer entities from CRM to Microsoft Power BI Filter report data by different dates in Microsoft Power BI Connect Microsoft Power BI Hide ID at the beginning of a text line in PowerBI Add multiple SPAs to a Power BI report