cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Writeback to Oracle database or SSAS server

Hi , 

We have SSAS tabular model and Multidimensional model on top of a Oracle Data warehouse . The reporting is done through  Power BI via a live connection to SSAS layer .

 

We have following requirements

  • Enable write back functionality for the users to enter comments that will be embedded into the report. 
    Question : Is it possible to write back to SSAS server using Power BI and store comments per line item on the report. Could it be stored in a    separate table or a dediated column can be created on a dimensional table to capture those comments.Has anybody ever  seen a solution like this or suggest an approach?


In case that is not possible , is it possible that we write back to Oracle Database from Power BI and then refresh the SSAS server models in real time in order to reflect  on the report . Please advise what are the recommended solution to achive this .

 

PowerApps ? or what are the options please !  

 

Thanks In adv.

2 REPLIES 2
Highlighted
Super User V
Super User V

Re: Writeback to Oracle database or SSAS server

Currently the only write back option is a PowerApps visual.

 

I am not aware of any other visual that lets you enter text on the fly.  If there is one then you could potentially use R or Python script for the write back.

Highlighted
Regular Visitor

Re: Writeback to Oracle database or SSAS server

While trying to writeback we have done a POC using R . There we can select something from drop-down that gets inserted on Oracle DB . We are battling while taking input from user on BI screen and then insert into the DB.

 

Any idea ?

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.