Blog site for Power BI, SQL and Excel
Tracking Power BI Report Access Across All Workspaces Using ADF and the Power BI REST API. One of the most common requests I receive as a data engineer is: “Can you get me a list of people who have accessed our Power BI reports?” At first, this sounded simple enough. Power BI’s built-in Usage Metrics …
Continue reading “Audit Trails Unleashed: Automating Power BI Logs to SQL via ADF”
I recently ran into a snag when I wanted to use Power BI for some projects at home. Like any curious data enthusiast, I downloaded Power BI Desktop to my personal laptop, excited to dive in. Almost straight away, I was met with an all-too-familiar screen: Power BI kept asking me to enter my email …
Ever wondered to see all the tables names and the last time they were updated? This is a query which will give you all the desired result. Select Distinct Object_name(object_id) as DatabaseName, Object_id, Database_id, Last_user_update From Sys.dm_db_index_usage_stats Where database_id = db_id() and last_user_update is not null