Power ON made a strategic choice in 2015 when Microsoft launched Power BI and Azure Analysis Services; to build Visual Planner solution inside Power BI. Fortune 500 companies as well as both mid-sized and larger corporations are now taking advantage of this unique and tight integration with Power BI. Most Microsoft and Power ON’s clients refer to this integration as mandatory and seamless.
With thousands of users entering data directly into Power BI, the demand for enabling new databases is on the rise. To support all Power BI users, Power ON has developed Writeback Anywhere and it integrates with latest releases from Microsoft like Composite Models (Direct Query over Analysis Services). The Writeback Anywhere Engine enables writeback functionality to any writeable data source supported by Power BI.
Writeback Anywhere has two working modes:
Write to Source DB
Write changes to a Writeable source and combine it in Power BI
The SQL Family Edition was launched in 2015 and it is used daily by thousands of Power BI users across the globe.
In the “Editions” table below it is easy to compare features and supported configurations.
SQL Family
Power ON’s Visual Planner was originally built around Microsoft SQL On-Premises or in the Cloud, since SQL natively supports CRUD(Create, Read, Update, Delete) functions.
Figure 1:
Standard
The left side of Figure 1 is referred to as Standard Edition. A Financial Modeler has a need to collect data and starts out with building a SQL Datamart, then connects SQL to a Tabular model on-premises or in Azure Analysis Services(AAS). Power BI Connects to the Tabular Model, and Power ON’s Visual Planner writes to the Source SQL DB.
Premium
Premium works like Standard, but it also supports Power BI Premium per User (PPU), Embedded or Premium Capacity. The Tabular Engine will then reside in a Power BI Premium configuration. The SQL engine itself can be located on-premises or in Azure SQL. This removes the need for a standalone SSAS/AAS engine.
Writeback Anywhere
Power BI provides connectors to a multitude of data sources which is very helpful for the business analyst to combine data from disparate storage media on-premises or in the cloud. Power ON’s Writeback Anywhere can be deployed for writeback in 3 different scenarios: Standard, Premium and Enterprise.
Standard – Business Analysts can Combine data from any Power BI supported datasource and enables users to edit this data with Power ON’s Visual Planner and write the changes back to a datasource that supports Direct Query (DQ).
Premium – BA users use Power Query for ANY datasource and publish it to Power BI in any Premium Capacity, and the writeback engine writes the results of the end-users input to a writeable datasource and combines in the Power BI Report.
Enterprise – In Enterprise mode, Business Analysts can take advantage of all modes including Power BI Composite Models. Corporations can build large data warehouses with billions of transactions in Azure or on-premises, combine them with Power Queries from any Power BI Datasource, and writeback to databases that stores end-user inputs and combines it in the Power BI Report. IT also tracks all changes in audit tables.
Writeback Anywhere Overview
Editions
Tabular comparison of all the different editions:
Data Sources
Sample Writeback to 50,000,000 records
Including BreakBack with Audit Trail in 2 seconds.
Note: All visuals refresh ‘automagically’. Press the button to schedule a demo and Whitepaper.
Risk Free
Implement today and get your money back if you are not satisfied.
Manage Cookie Consent
We use cookies to optimize our website and our service.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
We use cookies to optimize our website and our service.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.