SQL Database Auditing

[alakiran]

Hi,

I setup the SQL Database Auditing in PowerBI to pull all SQL Audit data and waited for couple hours and nothing is showing in the dashboards.  Dont know if i am doing anything wrong? How to troubleshoot any data refresh issue?

[v-shex-msft]

HI @alakiran,

>>I setup the SQL Database Auditing in PowerBI to pull all SQL Audit data and waited for couple hours and nothing is showing in the dashboards.

How did you setup and pull audit logs to power bi ? Can you please share more detailed information about this?

If you can't direct pull data for database, I'd like to suggest you use below t-sql query to create new table with audit logs, then get data from custom table.

SELECT * FROM sys.fn_get_audit_file ('\\serverName\Audit\HIPPA_AUDIT.sqlaudit',default,default);go

Reference:
sys.fn_get_audit_file (Transact-SQL)

Regards,

Xiaoxin Sheng

[alakiran]

There is a SQL Database Auditing PowerBI app service available in Power BI Service.

[v-shex-msft · Accepted solution]

HI @alakiran,

Based on research, it seems like you need to do some extra settings to turn on auditing logging.

I'd like to suggest you to take a look at below article to know to configuration azure sql auditing:

Get started with SQL database auditing

Regards,

Xiaoxin Sheng