cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mystery
Helper I
Helper I

Write back to database using Power BI report

Hello All,

 

I need to write back to the SQL database from a Power Bi report hosted using Power BI service.

 

What could be the best option next to Power apps,as Power apps has a license cost associated.

 

Please suggest.

 

Regards

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @Mystery,

AFAIK, power bi desktop does not include any writeback features. It is a reporting tool that is used to get data from specific data sources and design charts and visualizations.

If you want to do writeback operations, you may need to use external tools or integrated external features. (e.g. powerapps, r script, python)

Using Python in Power BI Power Query Editor - Power BI | Microsoft Docs

Use R in Power Query Editor - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

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

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

Hi @Mystery,

AFAIK, power bi desktop does not include any writeback features. It is a reporting tool that is used to get data from specific data sources and design charts and visualizations.

If you want to do writeback operations, you may need to use external tools or integrated external features. (e.g. powerapps, r script, python)

Using Python in Power BI Power Query Editor - Power BI | Microsoft Docs

Use R in Power Query Editor - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

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

View solution in original post

selimovd
Super User
Super User

Hey @Mystery ,

 

you could use custom visuals like Acterys Table Edit or the Power ON Power planner, but they are more expensive.

PowerApps will be the cheapest option.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

 

Thanks Denis.

 

Power apps is the obvious solution,I agree.

Could you please suggest any other option by which this could be achieved.

To give more details the requirement is that once the Power bi service renders the report a second report should be presented to the user which should have some fields in which the user can input planned values for the future.the same should be pushed back to the database,and the first report should pick up those changes and populate a graph accordingly.

 

anything other than power apps you could think of.

 

Regards

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!