Access to write back enabled SSAS cubes

[Baha]

I have had problems trying to access a write back enabled SSAS cube through the enterprise gateway. I have added it properly to the gateway and tested the connection. However, when i want to add it as a data set to a workspace i am still getting a data access error. Does Power BI service supports access to cubes that are write back enabled? Also i don't know why i am getting a credential error for the cube that i am connecting to (write back enabled).

[karaoan]

Hi @Baha As some of the other posters have already said write back is not supported for SSAS MD. https://www.Acterys.com offers write back capability for SSAS Tabular in addition to automated data integration of accounting and ERP solutions as well as enterprise planning functionality.

Let me know if I can help with further details.

Martin

[psolli]

Hi,

Writeback to Tabluar with both Import mode and Direct query is fully supported with Visual Planning from Power ON. There is also support for Multi-Dimensinoal. 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.

Per Solli

[v-sihou-msft]

@Baha

Currently, writeback functionality is not supported in Power BI. Please vote this Idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12903954-support-for-ssas-writeba...

Regards,