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

Data manipulation on Oracle via power BI Screen

We have a user_dealer table on Oracle DB that contains mapping between user and their dealers on which they can report on .

 

We are able to let the user to select and filter on them using Power BI .

 

However they don't want to run it individually rather want to club those dealers into a group for their reporting

So basically they would be doing following stuff.

1.Select individual dealer and group them into a list on power BI screen

2. Give a logical name to that list created above and that gets stored in the underlying oracle DB

3. They edit that group to add and remove any dealer as they need from the Power BI screen.

We are struggling to do data manipulation from user screen on power BI into the oracle database.

Is it possible or anyother approach ?

 

PS : Customer does not want to use POWER APPS and Power BI embedded. However they have SharePoint in use.

2 REPLIES 2
Highlighted
Super User VI
Super User VI

Re: Data manipulation on Oracle via power BI Screen

@Ranjan6214 

It's impossible to change data in a data source via Power BI 


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Highlighted
Community Support
Community Support

Re: Data manipulation on Oracle via power BI Screen

Hi @Ranjan6214,

AFAIK, current power bi not able ot use data view level fitler/slicers to interact or change the backend query table connections.
They are work on different data levels, the slicer/filter source table is a virtual table generated from the data model table(they are transformed and generated from query tables).

If you mean dynamic change the connected data source, it is possible if they have a similar data structure and connection mode.

You can refer to the following blog to parameterize your connection string with query parameters, then you can change the parameter and update your credentials to switch between different data source who has the same data structures.

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

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 Kudoed Authors