Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
I have created a power app that takes information from a power BI report and allows users to write data back to a sql database.
when I preview the app directly in power apps, I can save the form and I can see the data get updated in the database.
however, when I use the power app within power BI, I get the below error:
writeback.dbospwriteback failed: { "error": { "code": 403, "message": "Operation is not allowed", "source": "default-540c4cb1-7eb5-444d-a6cc-2f4b5bc92b4e.08.common.australia.azure-apihub.net", "path": "choose[3]\\when[1]\\choose\\when[1]", "policyId": "", "clientRequestId": "bb76c028-c3c7-46fd-8869-5ee1d8998250", "dreeSet": "true" } }
power apps calls a stored procedure that does an insert.
could there be some permission issue in power BI that is blocking it? I dont understand why it works directly in power apps but not when the power app sits inside of power BI.
Hi @WilliamA
Welcome to the Microsoft Fabric Community.
Below are the steps to navigate to cross verify the sql configuration.
1. How to verify SQL Connection in Power BI Service:
If the above information helps you, please give us a Kudos and marked the reply as a solution.
Thanks,
Cheri Srikanth
Hi @WilliamA
I think the error is likely due to a permissions issue. When embedded in Power BI, the app may use different credentials lacking SQL database writeback rights.
These should resolve the issue.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
Thanks @Poojarai, I am using power BI embedded "app owns data". is there a way to tell which credientials are being used? the power app sql connection is connected via an on-prem gateway and the sql account used in the power BI report has access to the database.
regarding the gateway - where are these permissions? I couldn't locate anything on the gateway around permissions.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
49 | |
28 | |
20 | |
20 | |
19 |
User | Count |
---|---|
52 | |
51 | |
26 | |
26 | |
22 |