Best Way to let user upload/update data in data model / underlying source

[Maeaex1]

Hi community,

what's the best way that users can upload/update data (e.g. an Excel File in Sharepoint) that is reflected instantaneous/real-time in a published PowerBI online report? I read about scheduled refresh, but this wouldn't be sufficient in terms of "real-time" actualisation. 

We have a PowerBI Report Server, but also suggestions for PowerBI Cloud Services (Pro/Enterprise) are welcomed. 

Thanks for your help & suggestions!

Best,

Max

[Jonvoge]

Hi Maeaex1

If you need real-time data updates, the key is to use a data source which supports DirectQuery.
This rules out Sharepoint as an option, and rather suggests using a SQL database or similar.

My personal go-to is to build a simple Power App as the user-facing application to accept inputs.
The Power App can easily be secured, and can be embedded directly in your Power BI reports as well for some pretty nice interaction. 

I published a step by step guide about this here: Guide: Add Write-Back to Power BI reports with Power Apps - Part 2: Display write-back data LIVE in ...

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[Maeaex1]

Hi Jonvoge,

Thank you for your help & reply!

Do you know if Power Apps can be programmed in a way that Copying the values of let's say 40-50 rows with 2 columns of an Excel Spreadsheet into the Power App would be possible? Or does the user then need to copy/paste every indiviudal value? The number of rows would be variable.

I wish you a great day ahead!

Max