Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Write back in a composite model

Hey guys,

So my customers wants to be able to add or adjust data to the Power BI report. The solution I created is with PowerApps, where they can enter data to an Excel file and joining the data back to the data model.


So far it is working.


The thing is, they will need to refresh the dataset and the report, to be able to see the data. Since we are working with a large datamodel, this takes a while.


I have been asked to demonstrate a real-time solution for the added data and create a composite model, both Imported data and Directquery. I have tried creating an API from Power BI Datasets, but after setting it up and investing a lot of time in it, it appears Power BI Datasets isn’t supported in a composite model.


Do you guys have any ideas on this?

Super User
Super User

I personally do not. I have not seen anything that is essentially real time or close to real time for this. I suppose if you were updating the Direct Query source using Power Automate tied to your PowerApp then that should essentially be real time but once you introduce the import component, I don't see how you get to "real time" because if you are updating the import portion of the data, then you have to run the import to update the data in the data model.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Hi Greg,


Exactlty. Thank you for your input. Helps to ease my mind that the answer is not that simple and it's not me. XD

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Kudoed Authors