cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Wuji
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?

2 REPLIES 2
Greg_Deckler
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!!!
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

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!