Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Hi @AnalyticPulse , it seems I can't find the explanation in your blog, would you mind to elaborate on this, please?
Hi @Morran
Try this video.
https://www.youtube.com/watch?v=uPHwjPRnRwE
I hope it may resolves your issue!
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
Hi @AnalyticPulse , thanks for your reply! Let me try to deep dive, hopefully it can work. Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
106 | |
88 | |
74 | |
69 |
User | Count |
---|---|
123 | |
112 | |
95 | |
83 | |
73 |