Forum Discussion
Solved
Writing data back and forth with PowerBI
Hello everyone, I’m exploring whether Power BI is a viable tool for the objectives we’re aiming to achieve in our company. Before diving deeper, I’d appreciate your insights on the following: ...
To answer your questions:
1. Yes, it can handle them.
2. Technically you can write data back. On practice you shouldn't do it. If you have already a SQL database that should be the source for all data. If you need to have calculations from Power BI written back, do them initially on the database. Power BI should be used to consume and report data. And yes, you can connect an Excel file to a database (or a Power BI semantic model as well).
Yes, Power BI can handle your workflow:
- Excel → SQL Server: Use Power Automate or Power Query to sync data.
- SQL Server → Power BI: Connect directly for real-time or scheduled updates.
- SQL Server → Excel: Use Power Query in Excel or Power Automate for sync.
- Power BI Auto-Refresh: Set up scheduled refresh or trigger via Power Automate.
For automation, use Power Automate to update SQL, refresh Power BI, and sync Excel.
Yes, Power BI can handle your workflow:
- Excel → SQL Server: Use Power Automate or Power Query to sync data.
- SQL Server → Power BI: Connect directly for real-time or scheduled updates.
- SQL Server → Excel: Use Power Query in Excel or Power Automate for sync.
- Power BI Auto-Refresh: Set up scheduled refresh or trigger via Power Automate.
For automation, use Power Automate to update SQL, refresh Power BI, and sync Excel.