Power apps integration doesn't contain all items in gallery

[alks_skla_f]

Hello,

- I have a table visual with contracts. The main column is "Contract ID". Table which contains this column is stored in Big query in import mode.

- The next important column is "Comment". This column is stored in Dataverse table in Direct Query mode. I don't know, maybe this is the issue?

The problem is that in my Power Apps I have only first entry (please take a look on gallery). However, in table visual I have a lot of entries.. 

I have already tried "Show items with no data". Does anybody know how to solve this issue?

When I choose second entry, form shows nothing:

Gallery. Items contains 'PowerBIIntegration'.Data, this line was automatically generated

[v-lgarikapat · Accepted solution]

Hi @alks_skla_f ,

Thanks for reaching out to the Microsoft fabric community forum.

@Shahid12523 

Thanks for your prompt response

@alks_skla_f Kindly try the troubleshooting steps and workarounds below and share how they work for you

It looks like your Power BI table is combining data from BigQuery (Import mode) and Dataverse (DirectQuery), and that mix can cause issues when syncing with Power Apps. First, double-check that the relationship between the two tables is active and properly defined on "Contract ID" ideally one-to-many from BigQuery to Dataverse. If the "Comment" column is blank or not resolving, it could be due to a join ambiguity or a DirectQuery limitation. In Power Apps, inspect the gallery’s Items property make sure it’s not using First(...) or a non-delegable filter that only returns one record. If you're using a collection like ClearCollect, confirm it’s pulling the full dataset and not just the first row. Also, be aware that Dataverse queries in Power Apps are subject to delegation limits, so complex filters or joins might silently truncate results. As a workaround, consider merging the two tables in Power BI using Power Query so the gallery reads from a single source, that Power Apps can consume more reliably. This way, you avoid the cross-source sync headache and get full control over what shows up in the gallery.

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

If you're still experiencing any challenges, please don’t hesitate to reach out  we’d be more than happy to assist you further.

We look forward to hearing from you.

Best regards,
Lakshmi

[alks_skla_f]

Hello, thank you for your answer!
1) Relationships look fine:

2) Gallery.Items contain 'PowerBIIntegration'.Data It was automatically created by Power Apps.

[v-lgarikapat]

Hi @alks_skla_f ,

I wanted to follow up and confirm whether you’ve had the opportunity to review the information we provided. If you have any questions or need further clarification, please don’t hesitate to reach out.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
Lakshmi.

[Shahid12523]

Your Power Apps gallery only shows one item because the Comment column is from Dataverse in DirectQuery mode, which Power Apps can't fully access. To fix it:
- ✅ Add Comment to the Power BI visual used for integration
- ✅ Switch Dataverse to Import mode if possible
- ✅ Or create a calculated column to materialize the data
This ensures Power Apps gets all the rows and fields it needs.

[alks_skla_f]

Hello, thank you very much for your reply. I can not switch my Dataverse to import mode, because I need to see changes dynamically.
What do you mean by "Add Comment to the Power BI visual used for integration", please?