Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
I was wondering whether the following is possible using microsoft power BI:
Multiple Excel Tables on different computers across the world with the same columns format (let's say country and some KPIs), which are integrated in one data model which is stored online. If new data (a new row) is added to an individual Excel Table, this is automatically updated in the online data model, which means all connected computers have a real-time overview of up-to-date data.
Does Microsoft Power BI offer possibilities to create the system described above, and if so, would anyone have any suggestions on how to create it?
Kind Regards, Rik
Hi,
Writeback to Tabluar with both Import mode and Direct query is fully supported with Visual Planning from Power ON. There is a great video here to get you started. http://poweronbi.com/powerbi-visual-planning/
You can also load data from Power BI to SQL with their solutions: http://poweronbi.com/2017/06/power-update-from-power-bi-desktop-to-sql-server
Power ON also has a Table Editor that lets you edit SQL Tables in Power BI Service directly. http://poweronbi.com/visual-table-editor/
Contact info is feedback@poweronbi.com
Visual Planner turns Power BI into a fully fledged Goal Seek and Planning, Budgeting and Forecasting solution. You can Goal Seek your DAX calculations.
Per Solli
Power BI is a reporting tool for rendering data. After you publish the report, any changes made in data source can be updated to the report on Power BI Service. In this scenario, I'm not sure if your Excel tables are data source feeding the online data model, or a reporting tool for rendering data from the online data model. I think what you are looking for should be something like Azure Analysis Services. To update data from on-premise to cloud, you can try writeback operation.
Regards,
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
61 | |
46 | |
45 |