Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
WilliamA
Frequent Visitor

Power App writeback to Sql server doesn't work from the service

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.

3 REPLIES 3
CSrikanth_21
Community Support
Community Support

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:

-> Access the Data Gateway Configuration:

  1. Log in to Power BI Service: Navigate to Power BI.
  2. Go to Settings:
    • Click on your profile icon in the top-right corner.
    • Select Settings.
  3. Choose Gateway Settings:
    • In the left panel, select Manage gateways under the Admin portal section.

-> Review Gateway Configurations

  1. Locate the gateway associated with your SQL Server data source.
    • Check the Name of the gateway from your Power BI dataset settings or workspace settings.
  2. Expand the gateway, and you will see the Data Sources configured under it.

->Check SQL Data Source Settings

  1. Click on the SQL Server data source to view its configuration.
  2. Verify the following settings:
    • Data Source Name: Ensure the name matches the expected SQL Server data source.
    • Server and Database: Confirm the correct SQL Server instance and database are specified.
    • Authentication Method:
      • Windows Authentication: User domain credentials.
      • SQL Authentication: Uses a username and password stored in the gateway configuration.
    • Credentials: If SQL Authentication is used, ensure the correct username and password are configured.

Step 1.4: Test Connection

  1. Click Test Connection to verify if the gateway can successfully connect to the SQL Server.
  2. If the connection fails, recheck the server details, database name, and credentials.

2. Verify SQL Connection in Power BI Embedded:

-> Access Power BI Embedded Configuration

  1. Log in to the Azure Portal: Navigate to Azure Portal.
  2. Locate the Azure Power BI Embedded Capacity:
    • Search for "Power BI Embedded" in the search bar.
    • Select your capacity resource.

-> Check Embedded Application Settings

  1. Go to the App Owns Data configuration or the code that embeds Power BI.
  2. Review the connection string or credentials passed from your app to the embedded report:
  3. Look for any hardcoded SQL credentials in your application code.
  4.       4.Check if the app uses a Service Principal or a user account.


If the above information helps you, please give us a Kudos and marked the reply as a solution.

Thanks,
Cheri Srikanth

 

 

Poojara_D12
Super User
Super User

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.

 

  1. Ensure the Power BI user or service principal has EXECUTE and INSERT permissions on the SQL database.
  2. Verify the SQL connection in Power Apps.
  3. Check gateway permissions if using an on-premises gateway.
  4. Review any Data Loss Prevention (DLP) policies.

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 

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 - Proud to be a Super User
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. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.