Forum Discussion
Use cases Power Apps and Power Automate together with Power BI
Hai all
1. Are there interesting use cases to extend Power BI with the other tooling from the Power Platform, Power Apps and Automate?
Please let me know.
2. We have so called manually maintained tables in SQLServer? Is there a way to a screen with Power Apps (in for instance Power BI) to update/insert/delete records in those manually maintained tabels? Is there somewhere a clear example?
3. Are there use cases to use Power Automate for for instance refreshing Power BI datasets, or is the scheduled refresh of Power BI itself enough?
I am very curiuos to you answers on my three questions.
Thank you very much
Regards
Ron
5 Replies
- amitchandak
Super User
Anonymous , power bi - Power Automate
https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
https://www.youtube.com/watch?v=HzvsQ_CYF88
Power bi - Power App
https://www.youtube.com/watch?v=LxuRzj0X348
Power App-power bi , we are using an enhanced version of first article inhouse
Thnx amitchandak
helpful information. I hope some people add more use cases.
By the way, I started trying to make an app based on an Excel file on my desktop. When I select Excel as a source for my form in powerapps.com I get an error saying: No tables found in Excel-file. The import function at this moment only supports table data.
Any idea?
regardsRon
v-zhenbw-msftCommunity Support
Hi Anonymous ,
Supplement the second point, please refer the following posts.
https://www.linkedin.com/pulse/write-back-azure-sql-database-using-power-bi-apps-aneek-arora
https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerApps-Writing-back-to-SQL/td-p/104348
For your issue about Excel, we suggest that you ask this issue in the Power Apps forum, you may get more professional answers.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-zhenbw-msft
Hi Anonymous ,
How about the result after you follow the suggestions mentioned in my original post?
Could you please provide more details or expected result about it If it doesn't meet your requirement?
If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
