Integrating Power Apps & PBI - Immediate Refresh - Data Source: Excel

[Morran]

Hello everyone. I hope you're doing well. 

I have a project regarding embedding Power Apps into Power BI. My intention is when user input the value in Power Apps, the updated data will be reflected on dashboard. Since my source is Excel file, I'm not sure if I can use storage mode directquery in my data modeling section. Do you have any experience using Power Apps with PBI while your data source is Excel File not in SSAS or SQL? Thank you for your advice

[Morran]

Hi @AnalyticPulse , it seems I can't find the explanation in your blog, would you mind to elaborate on this, please? 

[Uzi2019]

Hi @Morran 

Try this video.

https://www.youtube.com/watch?v=uPHwjPRnRwE

I hope it may resolves your issue!

[AnalyticPulse · Accepted solution]

i suppose you can do it with power automate by createeing a trigger when event is new entry is added to the excel. you can set the parameter to enter the record in powerbi dataset, or streaming dataset, its pretty easy.

If this helped, Follow this blog for more insightful information about data analytics
https://analyticpulse.blogspot.com/
https://analyticpulse.blogspot.com/2024/03/superstore-sales-2022-vs-2023-year-on.html
https://analyticpulse.blogspot.com/2024/04/commercial-real-estate-portfolio.html

[Morran]

Hi @AnalyticPulse , thanks for your reply! Let me try to deep dive, hopefully it can work. Thanks!