Power Platform Community Forum Thread Details

Hello experts,

I would really appreciate your advice here...

I have an App connected to a PowerBI dataset which contains a lot of data - well over 2000 rows. And I saw that the PowerBI dataset is not delegable....

I cannot filter it directly from PowerBI, as in my scenario the filter needs to be done from the PowerApp: I have plant codes and raw material IDs for each plant code, and in the PowerApp I have a vertical container with comboboxes, where the user selects the plant code for each line and this filters the raw material list:

If I did the filter in PowerBI, I would just have a single plant code in all comboboxes which I don't want - the App would lose its purpose.

But today, when I filter the plant first, the list of the raw materials does not include all items (it stops at row ~ 1600 of the original (not filtered) dataset for whatever reason, even if I increased the data row limit to 2000).

This is my formula for the raw material combobox:

Distinct(Filter(PowerBIIntegration.Data,'# Plant_ID_Desc'=FCCS_Plant_Desc1_cmb.Selected.Value),'# GMID_DESC')

Is there a workaround for this issue? How can I make this work correctly?

Thanks!

Kind regards

Valeria

Categories:

Building Power Apps