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!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

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.

Top Solution Authors