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.

     

aj1973's avatar
aj1973
Community Champion
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.

 

aquintana's avatar
aquintana
New Member
2 years ago

Thanks aj1973 for the confirmation that it won't work. I'll just implement the workaround.

 

As for your question: Yes, I can. but since I don't own the CRM Dynamics I think DQ mode won't work either, because I can't add new fields to the correspondent entity. Besides, our Dynamics is some kind of behemoth of a system, with hundreds of intertwined very large entities. Any previous attempt to use Direct Query in PBI has resulted in frustration without results.

 

Regards,