Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Brian Altman]

Anyone worked out a method to update a column from a row in a visualization?

For example, in a table visualization
1) Highlight a row
2) Update a column in the originating SQL table for that row.

——————————
Brian Altman
CTO

——————————

[Mike Hammons]

Hi Brian,

PowerOnBI has a couple of products that provide some write back capability. This might be close to what you are asking for:

Visual Table Editor

Poweronbi		remove preview
Visual Table Editor Visual Planning is getting a sibling. Lack of Data Quality is always Business Intelligence’s worst enemy. With Visual Table Editor from Power ON, users connect to any OLE DB data source, edit and manage Products, Customers, Employees, Numbers, Calendars and Text right in Power BI. View this on Poweronbi >

——————————
Mike Hammons
Director, Business Intelligence
AKA Enterprise Solutions

——————————
——————————————-

[Mike Hammons]

Just to follow up here as it may not have been clear in my initial response; PowerOnBI is an add-on/custom visual that works inside of Power BI and has write-back capability. 

——————————
Mike Hammons
Director, Business Intelligence
AKA Enterprise Solutions
Woodstock GA
770-926-5020
——————————
——————————————-

[Audrey Abbey]

I had a difficult time finding more info on this product, which is a shame. 
Apparently it isn’t something you can download/install/plug-in, but custom work they will do for you on a project basis. 

I am hoping they get it developed a bit more. 
It is a potential replacement for our finance department to do budget planning and such. 

——————————
Audrey Abbey
SR. BI Developer/Analyst
New Seasons Market
307-840-1825
——————————
——————————————-

[Brent Lightsey]

I don’t believe Power BI has any writeback capability.

Just a few days ago, MS announced the Power Apps custom visual for Power BI. It can accept as inputs selections and filter context from Power BI. 

So if you wrote a Power App to update a specific column in the source table, you could select that row using Power BI and initiate the change inside the Power App custom visual. 

Only in preview so far, but that’s the concept:
Announcing availability of PowerApps custom visual for Power BI (preview)

Microsoft		remove preview
Announcing availability of PowerApps custom visual for Power BI (preview) Take actions within your Power BI reports and dashboards with the PowerApps custom visual for Power BI (preview). View this on Microsoft >

——————————
Brent Lightsey
Analytics Consultant
FirstLight Analytics
Oklahoma, USA
——————————
——————————————-

[Jordan Fox]

Just starting using the visualization today.

Does it filter both ways? If I select something in my Power BI report it looks like, through watching videos, that the Power App gets cross filtered. What I can’t tell however is if I select something in my Power App, does it cross filter back to the report?

I could see #1 being really useful for say, adding annotations to a report. Simply have a table that connects to the date/statement/scenario etc and when they add comments, write to the appropriate rows. There’s a lot of scenarios where I’d like to also do the other filter though.?

——————————
Jordan Fox
Business Intelligence Consultant
Dakota Analytics
Calgary AB
250-516-0472
——————————
——————————————-

[Brent Lightsey]

, I don’t think that the PowerApp visual can then filter back to other Power BI visuals. In the limitations at the end of the article it mentions:

PowerApps custom visual cannot filter the data or send out any data back to the report.

Looks like that’s something they might work on. The only workaround I could see to this is if somehow the PowerApp set data records in the back end data source for your Power BI report that then served as a filter parameter for the data returned. You would have to be using DirectQuery to see that change reflect immediately, and even then, it would probably be necessary for the user to manually refresh the report after making the selection in the Power App.??

——————————
Brent Lightsey
Analytics Consultant
FirstLight Analytics
Oklahoma, USA
——————————
——————————————-

[Jordan Fox]

Yeah that was my thought. If I had say a comments table that was connected to date, product, and account IN my model, I would figure that selecting something that can filter that table would in effect filter the model. It doesn’t behave this way to my knowledge however.?

——————————
Jordan Fox
Business Intelligence Consultant
Dakota Analytics
Calgary AB
250-516-0472
——————————
——————————————-

[Brian Altman]

Thank you everyone for your help.   I will pursue the ideas and give folks update.

——————————
Brian Altman
CTO

——————————
——————————————-