In Power BI, you can limit the number of columns loaded from a BI entity. This helps improve data load speed and report performance.
For example, you may use deal custom fields in a report, but only a few columns are needed.
Select only the required columns to reduce the amount of loaded data.
Open the Transform data section to review the data currently loaded into the report.
Copy the names of the required columns and open the bx24_load_entity advanced editor.
Add the following command to the editor:
fields = {
[name = "DEAL_ID"],
[name = "DATE_CREATE"],
[name = "UF_CRM_1645431691305"]
}
Example fields:
- DEAL_ID – deal ID
- DATE_CREATE – deal creation date
- UF_CRM_1645431691305 – custom user field
For more information about entity fields, see the article Description of entity fields in BI Analytics.
After you save the changes, the entity will include only the selected columns. This reduces data load time and improves performance.
