You Can Now Write Data Directly in Power BI

Until now, Power BI has been an incredibly powerful tool for visualizing and analyzing data—but it had a key limitation: you couldn’t write or save data directly from within the report interface, unlike in Excel. This made workflows more complex whenever users needed to manually modify or input new data.

That limitation is now a thing of the past. Thanks to a strategic partnership between Bismart and Accobat, it’s now possible to write, edit, and save data directly inside Power BI, without needing access to a separate database or an external data entry system. This game-changing functionality opens up a new world of possibilities for organizations looking to interact with their data in real time from within their reports. Here’s how it works.

In this context, we have entered into a partnership with Accobat, a Danish company specializing in business planning and master data management directly from Power BI, and developer of the innovative accoTOOL suite.

This collaboration is an important step forward in our strategy to offer our customers more complete, more integrated and more action-oriented tools.

Accobat: Planning and Writeback in Power BI

Accobat is a consulting firm with a strong track record in business planning and data management solutions.

Based in Denmark and with a growing international presence, Accobat has established itself as one of the leading developers of writeback and advanced planning tools integrated with Power BI.

Its value proposition revolves around a simple but powerful idea: giving end users full control over their data, within the environment in which they already work: Power BI.

At the core of their technology offering is accoTOOL, a suite of visuals available on Microsoft AppSource that allows you to transform Power BI dashboards into true management and planning environments.

• Find out how it works and what accoTOOL does in our guide: "The 15 dashboards every leading company should have in 2025".

A Strategic Alliance To Empower Power BI Users

The collaboration between Bismart and Accobat stems from a shared vision: to turn Power BI into a tool not only for analysis, but also for action.

Traditionally, business intelligence tools have been used to visualize data, generate reports and gain insights. However, the move to direct decision making, planning and integrated management was still a challenge for many organizations.

With accoTOOL, that challenge disappears. And with Bismart's expertise in developing enterprise solutions on Power BI, this partnership enables us to offer our customers a new level of functionality and efficiency.

accoTOOL: Interaction, Planning and Management Within Power BI

One of the main advances introduced by accoTOOL is the write-back functionality, which allows users to write data directly from Power BI to a SQL database, opening up a range of possibilities previously limited to external tools.

Since the introduction of accoTOOL to the market, many companies have been able to simplify their planning, resource management, budgeting and master data maintenance processes, thanks to the ability to:

• Add, edit or delete data directly from reports.
• Validate entries through customized rules.
• Audit changes made by users.
• Manage versions of budgets or forecasts without confusion.

In addition, accoTOOL is natively integrated with Power BI security, respecting the access levels and permissions defined by the organization, ensuring data governance in Power BI at all times.

accoPLANNING and accoMASTERDATA: Two Complementary Solutions

The accoTOOL suite includes several specialized tools, among which accoPLANNING and accoMASTERDATA stand out, designed to cover two key areas: operational planning and master data management.

accoPLANNING

accoPLANNING is geared towards financial, resource and supply chain planning. Its interface is reminiscent of a spreadsheet (Excel-like), but fully integrated with Power BI. Its main functionalities include:

• Transactional scripting (Translytical): allows you to modify data and save changes in real time.
• Audit log: complete record of who did what and when.
• Splashing: to apply changes to multiple cells at once quickly and efficiently.

With accoPLANNING, planning teams can work more agile, avoiding duplication, reducing errors and eliminating the need for external tools or manual processes.

accoMASTERDATA

accoMASTERDATA is designed for the management and maintenance of master data, allowing to create, update and validate records directly from Power BI. Some of its outstanding functionalities are:

• Hierarchical dropdowns to facilitate data selection and entry.
• Advanced validations, which guarantee the integrity of the data entered.
• Total control over rows and columns, with the possibility of adding or deleting elements from the visualization itself.

Thanks to this tool, companies can ensure a clean, consistent and well-governed database without relying on manual processes or parallel systems.

Advantages of the Partnership for Bismart Customers

This agreement allows Bismart to integrate accoTOOL's capabilities within its customized Power BI solutions, which translates into tangible benefits for our customers:

• Integrated planning: The entire process, from analysis to action, occurs in the same environment.
• Time savings: Cases such as Whiteaway Group, which managed to reduce between 1 and 2 weeks of work thanks to accoPLANNING, are proof of the real impact of these tools.
• Error reduction: By eliminating manual steps and facilitating validation at source.
• Better user experience: The tools are designed for the end user, with intuitive and secure interfaces.
• Scalability and governance: The solutions are fully scalable and aligned with Microsoft security policies.

What Can We Do Together?

At Bismart we are already working on incorporating accoTOOL into our enterprise solutions in Power BI. This includes everything from financial planning dashboards, to complete data governance solutions or master catalog maintenance.

If your organization needs:

• Plan directly from Power BI.
• Reduce Excel dependencies.
• Manage data from a single environment.
• Improve traceability and change control.

accoTOOL may be the missing piece in your BI architecture. And Bismart is ready to help you implement it with the quality and guarantee that characterizes us.

Before you go...