Forum Discussion

Frequent Visitor

1 year ago

SQL Audit Logs

I tried to enable logging of UPDATE-Statements for the Warehouse (SQL Audits). I don't want to include SELECT-Statements, since this would increasy the volume of actions that are logged. Bases on ...

Frequent Visitor

11 months ago

Thanks. The response returns "enabled".

I included the empty line after the bearer token (somehow removed it in this post).

In general, it works for audit action groups.
However, I am not able to only capture UPDATE statements without capturing SELECT statements.

v-nmadadi-msft
Community Support
11 months ago
Hi FabricH ,

Can you confirm if your Warehouse is using snapshots which is also in preview, there is a limitation where SQL Audit logs is not supported in Warehouse Snapshots.

I hope this information helps. Please do let us know if you have any further queries.
Thank you
- FabricH
  Frequent Visitor
  11 months ago
  v-nmadadi-msft
  No snapshots exist in the warehouse.
  Maybe I need to use a different API endpoint (not specified in the documentation).
  Since in the documentation, the don't call this "audit action groups", but "individual audit actions".
  - v-nmadadi-msft
    Community Support
    11 months ago
    Hi FabricH ,
    Sorry to know it didn’t help. Please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your admin account setup or provide a solution that isn't immediately obvious.
    
    Below is the link to create Microsoft Support ticket:
    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
    Thank you

Related content