Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Baha
Regular Visitor

Access to write back enabled SSAS cubes

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).

 

 

powerBI connection.png

3 REPLIES 3
karaoan
Kudo Commander
Kudo Commander

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
Advocate II
Advocate II

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
Employee
Employee

@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,

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors