Forum Discussion

FabricH's avatar
FabricH
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 ...
data warehouse
Warehouse
v-nmadadi-msft's avatar
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's avatar
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's avatar
    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

    • FabricH's avatar
      FabricH
      Frequent Visitor
      11 months ago

      thanks!