Forum Discussion
Power Apps Visual Not All Fields Showing
I am having a terrible time connecting a Power App to the Power BI integration.
Every time I create the app, some of the fields I have added to the visual are not in the app itself. For example, by adding First(PowerBIIntegration.Data).FieldName to a label, I am only given some of the fields I added to the visual, not all.
It seems to be the bottom fields that are missing (i.e. the first four are available and the bottom three aren't). It's never a mix, it's always the last ones added to the visual that aren't present.
The fields are comprised of 2 measures and 6 columns. The model is a simple star model with two dim tables and one main fact table.
I am also unable to open the app by selecting the elipse and clicking Edit as this doesn't open the app! I have a second issue on this forum about that too...
I got to the bottom of it (I think). I made all the fields come from the same table (except measures), by adding calculated columns and RELATED().
Annoying that I had to add extract calculated columns to get it to work but that has done the trick. Looks like there is a lot of processing when adding multiple columns from related tables - the loading spinner in the corner of the visual never stopped before, but after this approach it went away after a second.
1 Reply
I got to the bottom of it (I think). I made all the fields come from the same table (except measures), by adding calculated columns and RELATED().
Annoying that I had to add extract calculated columns to get it to work but that has done the trick. Looks like there is a lot of processing when adding multiple columns from related tables - the loading spinner in the corner of the visual never stopped before, but after this approach it went away after a second.