Log Analytics · Power BI

The ExtAuth Trace Event In Power BI

When you’re looking at the Log Analytics data for your Power BI Premium dataset, or studying a Profiler trace, you may see a command called ExtAuth in the OperationDetailName column:

It is documented here as “An internal service-generated command to perform authentication” – and as such it’s not something you have any control over. It may be triggered when a report is opened or a dataset refresh is started.

However you may wonder why it’s so slow sometimes. This is because datasets in the Power BI Service are not held in memory 100% of the time (they are sometimes paged out to disk) although they do need to be in memory before they can be queried or refreshed. When a dataset is not held in memory but the Power BI Service needs to connect to it, the dataset is loaded into the Analysis Services engine and into memory and this can take some time, especially if the dataset is large. The ExtAuth event is often the event that triggers the load of a dataset into memory and therefore the time required to load the dataset into memory is associated with it.

[Thanks to Akshai Mirchandani, Kay Unkroth and Rui Romano for the information in this post]

3 thoughts on “The ExtAuth Trace Event In Power BI

    1. Chris Webb – My name is Chris Webb, and I work on the Fabric CAT team at Microsoft. I blog about Power BI, Power Query, SQL Server Analysis Services, Azure Analysis Services and Excel.
      Chris Webb says:

      It’s the same thing?

      1. Not sure about the actual mechanics but I would assume that it’s a one way process. A dataset resides somewhere in Azure storage, and when requested (and when possible) it will be loaded into the capacity memory. When it gets evicted it only gets removed from the capacity memory but there’s no need to page it to disk as it is already stored on disk. Unless that storage is slow and you have implemented some sort of hot disk cache.

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.