Forum Discussion

aquintana's avatar
aquintana
New Member
2 years ago
Solved

Write back to a PowerBi Source (PBI Report) using Power Apps

Hi there,   Sorry if this question is not new. I haven't been able to find a similar case in the forums. Maybe is more of a Power Apps issue.   I want to use Power Apps to write back to a Power B...
Need Help
  • aj1973's avatar
    aj1973
    2 years ago

    Hi aquintana 

    Power BI is a read only SaaS, therefore nothing can help you write back to the source.

    However the work around you thought about is not bad and you can even build a Power App on top of the SharePoint list or table.

    I have to ask though, can you not connect the pbix file directly to Dynamic 365 on DQ mode? It would be much easier.

     

djacobson1's avatar
djacobson1
Regular Visitor
1 year ago

I am new to Power Apps and I have a similar issue. I have a Power BI report. In one of the SQL tables, I created a Custom_Key as well as a Notes column. The Custom_Key is populated via a dax formula.  The Notes column is empty. I want to "write back" to the Notes column using Power Apps. 

 

In the Semantic Model, I used the Power Apps Visualization to select fields from the SQL table to appear in a Power Apps Gallery. I can then enter Power Apps, attach the SQL table using a custom connector to a SQL database, and create a Gallery with the fields I selected in the Semantic model including the Custom_Key and Notes fields.

 

However, when I add a Form in Power Apps to enable "write back" and attach the SQL datasource from the step above, I see the original fields in the SQL table but I do not see the columns I added to the table, i.e. I do not see Custom_Key or Notes. I have published both the Semantic Model and the Power App I created. 

 

Any thoughts?