Forum Discussion
Helper IIntegrating Power Apps & PBI - Immediate Refresh - Data Source: Excel
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
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
4 Replies
- AnalyticPulse
Solution Sage
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
MorranHi AnalyticPulse , thanks for your reply! Let me try to deep dive, hopefully it can work. Thanks!
Uzi2019Community Champion
Hi Morran
Try this video.https://www.youtube.com/watch?v=uPHwjPRnRwE
I hope it may resolves your issue!
- Morran
Hi AnalyticPulse , it seems I can't find the explanation in your blog, would you mind to elaborate on this, please?