Forum Discussion

alks_skla_f's avatar
alks_skla_f
Helper II
11 months ago
Solved

Write back to PBI dashboard doesn't work with Direct Query

Hello, I have 2 tables: "A" and "B". Table "A" is stored in BigQuery and was uploaded in PBI in import mode. Table "B" is stored in Dataverse in uploaded in "DirectMode" in PBI.
- Table "A" column: "Contract_ID".

- Table "B" column: "Comment"
I integrated Power Apps into Power BI:

When I create relathisonsips between table based on key value. Power Apps doesn't work properly. User from this forum suggested to merge table in PowerQuery and it works! Every time when I click on contract, it is populated in form. Maybe this is a problem (that I use merged table instead of directly using table "A" and "B")? 

The problem is: when I put a comment in field in Power Apps -> click button -> the record is saved in Dataverse, but it is not populated in PBI visual. How I can solve this problem, please? I need to see comments dynamically?

Key points:
- I use DirectMode for table "B"
- I use table "C" for PBI visual: this is a merge of table "A" and "B"

- I use PBI desktop
 

Need Help
  • Shahid12523's avatar
    Shahid12523
    11 months ago

    - Merging Import (Table A) and DirectQuery (Table B) in Power Query creates a static snapshot.
    - Power Apps writes back to Table B, but merged Table C doesn’t auto-refresh.
    - To fix it:
    ✅ Use separate tables with a DAX relationship
    ✅ Bind Power Apps directly to Table B
    ✅ Add PowerBIIntegration.Refresh() after submit to refresh visuals

3 Replies

  • SamsonTruong's avatar
    SamsonTruong
    Super User
    11 months ago

    Hi alks_skla_f ,

    Since Table C is created by merging a DirectQuery table with an Import table, it is materialized and treated as Import. Because of this, you will need to refresh Table C in order to see the latest results.

    If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

    Thanks,

    Samson

     

    Connect with me on LinkedIn

    Check out my Blog

    Going to the European Microsoft Fabric Community Conference? Check out my Session

  • Shahid12523's avatar
    Shahid12523
    Community Champion
    11 months ago

    - Merging Import (Table A) and DirectQuery (Table B) in Power Query creates a static snapshot.
    - Power Apps writes back to Table B, but merged Table C doesn’t auto-refresh.
    - To fix it:
    ✅ Use separate tables with a DAX relationship
    ✅ Bind Power Apps directly to Table B
    ✅ Add PowerBIIntegration.Refresh() after submit to refresh visuals

  • v-achippa's avatar
    v-achippa
    Community Support
    11 months ago

    Hi alks_skla_f,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you SamsonTruong and Shahid12523 for the prompt response. 

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa